Refresh the data in power bi report server automatically.

[srana]

Hi Team,

I'm taking data from Denodo into Power BI and the report is published in Power BI Report server.

I want the report to be refreshed automatically whenever the data is refreshed in denodo.
I am aware of schedule refresh and all but the report should refresh with new data when the data is refreshed in database.

Is there an API or script ?

[v-luwang-msft · Accepted solution]

Hi @srana ,

You can find the cache refresh plan for a report via the REST API like this

http://localhost/reports/api/v2.0/PowerBIReports(6654B9C1-8A84-432E-BC5F-883103A22832)/CacheRefreshPlans

Which gives you the ID of the cacheRefreshPlan. You can obviously figure out the reportID (GUID) using the REST-API

You can then access the cacherefreshplan using this

http://localhost/reports/api/v2.0/CacheRefreshPlans(ac452376-cfda-4772-8cf4-6b5a59ea321b)

Now the swagger documentation says you can make the cache refresh plan run using a POST request to

http://localhost/reports/api/v2.0/CacheRefreshPlans(ac452376-cfda-4772-8cf4-6b5a59ea321b)/Model.Exec...

Similar case refer:

https://community.powerbi.com/t5/Report-Server/Is-there-any-REST-API-to-Refresh-Data-for-PBIX-files-...  

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien