Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Refresh the data in power bi report server automatically.

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....
Need Help
v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

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.Execute

 

Similar case refer:

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

 

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


Best Regards

Lucien