cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kenny_i Member
Member

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
v-huizhn-msft Super Contributor
Super Contributor

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

Hi @kenny_i,

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. 

4.PNG

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

1 REPLY 1
v-huizhn-msft Super Contributor
Super Contributor

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

Hi @kenny_i,

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. 

4.PNG

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

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 162 members 1,727 guests
Please welcome our newest community members: