CODEWITHSUNDEEP
powerbirefresh
Asyz
Asyz

Reputation: 1

Auto-Update of Published Power BI Report on Web

I’m currently exploring options in Power BI since the client is requesting a report that auto-refreshes, as it will be displayed on a television in their office.

For now, I’m creating a report where the data source is from the web (OneDrive), and the data in OneDrive updates automatically every 15 minutes. Then, I published the report from Power BI Desktop to Power BI Service, where I have configured the scheduled refresh. Currently, my report updates every 3 hours.

However, when I publish the report to the web, the published version does not update, even though the report in Power BI Service is updated successfully. Does anyone know how I can make the published report update automatically?

Alternatively, does anyone have a better idea for creating a report that auto-refreshes if it needs to be displayed on a television?

Upvotes: 0

Views: 78

Answers (1)

Arya
Arya

Reputation: 341

You can enable the Auto Page Refresh from the page setting Page refresh setting

This option will only be available when a Direct Query connection is available in the report.

It will refresh the data what is available in the report. So for this we need a source to which you can connect using Direct Query Method e.g. SQL

If the Source is onedrive (in this situation), you can schedule the report as frequent as possible and add a Direct Query with any available SQL Server using Query

SELECT 1 Direct Query

Then setup the Auto refresh, and Auto Page refresh will load the data on the page.

Hope this helps.

Upvotes: 0

Related Questions