![\"\"](\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/05\/image.png\")
<\/a><\/figure>\n\n\n\nNext, we need our data intake container where we store the data which will imported into out Power BI environment.<\/p>\n\n\n\n To this container I upload a simple CSV file Next, we need our Stream Analytics Job, you will find this resource at the Azure marketplace:<\/p>\n\n\n\n Please ensure that you create this job at the same region as you created the storage account. By creating this job, I leave everything by default. The Units are by default at 3 and can scaled up by need and after creating this resource.<\/p>\n\n\n\n After a successful deployment we need to configure the data in-take. You can configure this by navigating zo input and select \u201cnew\u201d and Blob storage. For the Authentication mode I select \u201cconnection string\u201d. By selecting this, maybe you need to provide a key, this key can be grab from your storage account under access keys. Please make also sure, that you configure the data format to CSV with semicolon as a delimiter.<\/p>\n\n\n\n Now we need our output. For this I created at my Power BI tenant only a new workspace. You can use an existing, but to get a better overview for myself, I created a new one. By selecting outputs, I created a new with Power BI.<\/p>\n\n\n\n By going back to the Overview, we can edit out query which selecting our data from the input and push the data to the output.<\/p>\n\n\n\n Now everything is ready, and we can start the job. After that, and we provide new data, we get a new dataset in our Power Bi workspace where we get our data from the blob storage. To provide new data, you can easily upload a new file. You can check this at the overview page.<\/p>\n\n\n\n By creating a new report at Power BI based on the new dataset, you can check the data. The dataset contains additionally some information about the data file and the import process. I think it makes more fun when you automatically get new data, for this approach I created a PowerShell script. You need by configuring this script also the access key from your blob storage. After that, you can run this script in a loop.<\/p>\n\n\n\n <\/p>\n","protected":false},"excerpt":{"rendered":" Azure Stream Analytics can used to stream data to different targets and to Power BI. In this post, I will show how to stream data to a Power BI dataset from a Blob storage. Normally you will get at this … Continue reading <\/a><\/figure>\n\n\n\nCategory;Date;OrderId;Amount
Trucks;9\/5\/2021;763;2289<\/code>
Imagine that your store will send you for ever sale a file which should be immediately available in your Power BI report.<\/p>\n\n\n\n<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\n$accesskey = \"f1vxAsiHHWvdEF8lfAExLq66rghWfqzXZoR3ugq9p5qnqDTnIt4DAUvz4luHEJ5w1Gbcg+yy6jT+EEvHJGaXtA==\"\n$StorageAccountName = \"streamingdata0105\"\n$containerName = \"data\"\n\n$date = Get-Date\n$category = \"Trucks\"\n$amount = $date.Millisecond\n\n\n$filename = $category + $date.Hour + $date.Minute + $date.Second + \".csv\"\n$path = \"c:\\temp\\files\\\"\n$tempfilepath = \"c:\\temp\\files\\\" + $filename\n\n$output = @()\n$output = @(\"Category;Date;OrderId;Amount\")\n$output += @($category + \";\" + $date.Day + \"\/\" + $date.Month + \"\/\" + $date.Year + \";\" + $amount + \";\" + $amount * 3) \n$output | Out-File -FilePath $tempfilepath\n\nConnect-AzAccount\n$StorageContext = New-AzStorageContext -StorageAccountName $StorageAccountName -StorageAccountKey $accesskey \nSet-AzStorageBlobContent -File $tempfilepath -Container $containerName -Blob $filename -Context $StorageContext <\/code><\/pre>\n\n\n\n<\/a><\/figure>\n\n\n\n