How to refresh automatically data in Report using Azure Blob Storage data?

[Anonymous]

I have Azure Storage Blob. It is receiving streaming IoT Data. I have succesfully created reports using Power BI Desktop and succesfully publishded to Power BI Service portal. However I don't get data refreshed automatically. How to make reports up to date real time or at least update every 10min?

[v-huizhn-msft · Accepted solution]

Hi @Anonymous,

You get data from Azure Blob Storage, and publish it to service, you just create a refresh schedule, the data will automatically update according to your schedule. Because get data from Azure, so you don't need a gateway. I test it using the sample table in this post. I create a report, and publish it to service. 

In Power Service, please right click Dataset->Schedule Refresh, you will get the following screenshot. Please Edit Credentials using your Account. Turn on the "Keep your data up to date", and you can choose Daily/Weekly refresh frequency. Finally click the "Apply", the data will update automatically. 



In addition, if you want to refresh real time or at least every 10 mins. You will have two options.

For one thing, you can purchase Power BI Premium, there is no refresh frequency limitation for premium account. You can update data at least every10 mins. 

For another, for making reports up to date real time. You can create Azure Stream Analytics getting streaming IoT Data instead of Azure Storage Blob. Then you can create a real-time dashboard by Azure Stream Analytics. For more details, please review the following articles.

Get started with Azure Stream Analytics to process data from IoT devices
Stream Analytics and Power BI: A real-time analytics dashboard for streaming data

Best Regards,
Angelia