2018-10-22         Ford

PowerBI and Stream Analytics - Auto refresh doesnt work

I have used Azure Stream Analytics to Import Data from a Hub - it worked.I created an output to Power BI, and created a live Dashboard in Power BI with the dataset from Stream Analytics - it worked as well.Now, if I manually refresh the report (reload the page), the newest data will be displayed (I push 100 rows in a minute from Azure to Power BI). But if I view the report in the browser, and I do not manually refresh, the report doesn't refresh automatically. Can anyone give me a hint?Thanks in advance! When using Power BI to view streaming data, it doesnt currently all...

 azure                     1 answers                     66 view
 2018-10-22         Evan

View raw data in power bi

I have stream analytics in azure that sends data to power bi. The data is a complex JSON and I am trying to write a proper query for stream analytics to get the data I need. I wrote some query, but it returns a record and I cannot figure out what fields are inside the record. In power bi if I drag the field, it just says Record. I assume this is probably a list of JSON records. Is there any way to see the record as JSON or raw text in Power BI (or anywhere else)? I want to see the output of stream analytics, so I could improve my query. Instead of outputting to Power BI...

 azure                     1 answers                     71 view
 2018-10-22         Erin

Sending tags containing special characters to Azure Notification Hub

We want to use Azure Notification Hubs in our iPad app but we have run into a problem. The tags that determine who gets the push message is an email address and it works fine if it only contains normal characters. But it does not work when we try to send a tag looking like this:test+10@gmail.comortest%10@gmail.comWe are using this method to send push from the backend:http://msdn.microsoft.com/en-us/library/windowsazure/dn539552.aspxWhen we do so we get this message:Invalid tag test+10@gmail.com.TrackingId:48b6f399-3f27-40b4-a6f9-b0838623c9c3_G19,TimeStamp:12/10/2013 12:38:3...

 azure                     2 answers                     103 view
 2018-10-22         John

What is the registrations per second throughput for Azure Notification Hub

Does anyone know what is the registrations per second throughput for Azure Notification Hub?I ran a background task to sync NH with our user database however it started to recieve timeouts from notifcation hub - presumably some throttling. We found that we could process around 18,000 registrations per hour (300/second) without any issue. The peak hour in the graph when it failed shows 44,000 registrations in that hour. I work on Windows Azure Notification Hubs. The one you report above is indeed the max throughput that we allow on our system for registration operations.W...

 azure                     1 answers                     7 view
 2018-10-22         Sampson

Azure Mobile Services scripting createNotificationHubService

I was calling a Notification Hub to push a message on insert script of a table just fine, but all of a sudden when I call:var azure = require('azure');var hub = azure.createNotificationHubService('<hub name>', '<connection string>');I get an error saying: Error in script '/table/moves.insert.js'. TypeError: Object [object Object] has no method 'createNotificationHubService' at insert (</table/moves.insert.js>:4:21) at </table/moves.insert.js>:1:8 [external code]Is this an Azure bug or has the method changed? It was a bug with Azure. I got t...

 azure                     1 answers                     6 view
 2018-10-22         Orville

Stored Procedure in azure sql database query tables in another azure sql database

I have two azure databases say DB1 and DB2.DB1 has got few tables and I want to create stored procedure in DB2 to cross query with joins in the tables in DB1. I have seen examples with Cross Database query but mostly showing only single table. My Stored procedure is like:select u.UserID as [UserID], u.Username as [UserName], u.LastLoginDate, ISNULL(au.IsDeleted, 1) as [IsDeleted] from DB1.[sec].[User] ujoin DB1.[sec].[AppUser] au on (u.UserID = au.UserID)join DB1.[sec].[Application] a on (au.ApplicationID = a.ApplicationID)where (a.Name = 'name')...

 azure                     1 answers                     76 view
 2018-10-22         Edison

Bulk upload Excel to SQL Azure daily

I have a requirement to bulk upload data from a excel file to an Azure SQL table on a daily basis. I did some research and found that we could create a VM install full SQL and use SSIS package to do this. Is there any other reliable way to go about this? The excel may contain up to 10,000 rows. I have also read we could upload file to a blob storage and read from there but found it's not very robust approach.Can anyone suggest if this is feasible approach- Place excel file in Azure Website accessed via FTPAzure Timer job using SQL Bulk copy code to update the SQL table Any ...

 azure                     1 answers                     7 view
 2018-10-22         Rodney

MSMQ on Azure Website

I have an existing ASP.NET Web Service (asmx), which I am trying to move into Azure. The logging component of the web service logs the messages in to MSMQ and there is a windows service which reads the message and update the database.Is this possible using Azure Web APP (Websites) ? Will the web service code be able to create message queues at run time and could push messages into it? MSMQ isn't available as an Azure service and you can't create a Windows service with App Service. What you can do is use a storage queue instead of MSMQ with minimal impact on your Web ser...

 azure                     1 answers                     28 view
 2018-10-22         Myra

What permissions does Azure Mobile Services use to access an Azure SQL Database with the mssql object?

I have set up an Azure Mobile Service (AMS) that's associated with an Azure SQL database, as usual. However, when I try to use a custom api to query another table (NOT a mobile services table) with the custom API mssql object, I get a permissions error: Error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'zwxABOesblahblahHYzLogin'.Some things to note:I had to drop delete the database and then re-create it with the same name after the mobile service was created. Mobile service name is 'abc', and the table I'm trying to access is owned by an 'a...

 azure                     1 answers                     33 view
 2018-10-22         Myrna

Cosmos DB with multiple partition keys

We're looking at potentially using a single Cosmos DB collection to hold multiple document types in a multi-tenanted environment using a tenant ID as the partition key. The path to tenant id may change in each document type and I am therefore looking at various was of exposing the partition key to Cosmos DB to enable correct partitioning / querying.I have noticed that the Paths property of DocumentCollection.PartitionKey is a collection and was therefore wondering whether it is possible to pass multiple paths during the creation of a document collection and what the behavio...

 azure                     2 answers                     45 view
 2018-10-22         Marcia

Hive Table migrate to different env

I have a Hive Table on Azure HDInsight WASB, want to migrate / copy over from Production to QA environment, looks like I can only do it via export / import.1) Export tables from parquet to files (metadata included)2) AzCopy from Prod Storage to QA Storage3) Import tables Azure HDInsight supports only export/import Hive metastore.If you want to retain your Hive tables after you delete an HDInsight cluster, use a custom metastore. You can then attach the metastore to another HDInsight cluster.Note: An HDInsight metastore that is created for one HDInsight cluster version ca...

 azure                     1 answers                     51 view
 2018-10-22         Bernice

Azure ARM template deployment

I am trying to create NIC card for VM through Azure ARM template. But my script also creates concats NIC to app gateway. But as of now I am only creating VM and NIC. Is there a condition to skip the Concatenation of App gateway and NIC. Below is the NIC creation template:{ "comments": "NIC_Creation", "tags": { "owner": "[parameters('owner')]" }, "condition": "[equals(parameters('CreateVM'), 'yes')]", "dependsOn": [ // "[resourceId('Microsoft.Network/publicIPAddresses', parameters('VM_PublicIP_Name'))]", // "[resourceId('Microsoft.Network/...

 azure                     2 answers                     50 view
 2018-10-22         Yehudi

Adding Load Balancer Rule via Powershell

I'm attempting to add a load balancer rule via Powershell as we need to open multiple ports for passive ftp.Connect-AzureRmAccountSet-AzureRmContext -SubscriptionId "MySubId"$slb = Get-AzureRmLoadBalancer -Name "MyLB" -ResourceGroupName "MyRG"$prb = Get-AzureRmLoadBalancerProbeConfig -Name "MyProbe" -LoadBalancer $slb$beaddpool = Get-AzureRmLoadBalancerBackendAddressPoolConfig -Name "BEADDPOOL" -LoadBalancer $slb$slb | Add-AzureRmLoadBalancerRuleConfig -Name "PassivePort_50010" -FrontendIPConfiguration $slb.FrontendIpConfigurations[0] -BackendAddressPool $beaddpool -Protoco...

 azure                     2 answers                     60 view
 2018-10-22         Elsa

How are 3rd party dll's referenced on Azure App Service

I have a simple webapi solution (aspnet core 2.1) consisting of two projects, Test.api (containing a controller) and Test.Models. The Models project has Newtosoft package and uses JsonIgnore attribute on models. When I deploy this solution to Azure app service and view the contents of the deployed folder via cloud explorer (also used kudu), I don't see the Newtosoft dll.Where is it being referenced from? Does app service have an equivalent of GAC? I don't know how the GAC works for .NET Core but it should reflect a regular Windows system, in essence that's what App Servi...

 azure                     1 answers                     62 view
 2018-10-22         Marjorie

Azure Powershell Script: File Path (What path to mention here)?

I am creating a release pipeline using Azure PS Script. I uploaded the Script along with the code in VSTS _git. I tried lot of options but no luckPlease help me to understand what path i need to mention here. Refer Copy Artifacts Step & Publish Artifacts Step online; add those if you are missing in the build definition.Artifacts should be available in the system folder named,$Build.ArtifactStagingDirectory\YourFolderName. [XXX]

 azure                     1 answers                     85 view
 2018-10-22         Lambert

Text Split cognitive skill not visible in UI

I am adding Azure Search and trying to add skills for content enrichment.I can see the Key Phrase Extraction and the Language Detection predefined skills but not the Text Split skill on the screen. Is there a reason why Text Split skill is not visible? Or is it something that can only be added via API? The capabilities exposed throught the portal focus on core scenarios that customers want to perform so they do not include text splitting. If you want to split your text, you should do it by creating your own skillset programatically through the API, that will allow you t...

 azure                     1 answers                     110 view

Page 1 of 625  |  Show More Pages:  Top Prev Next Last