Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Solved! Go to 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:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
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:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
14 | |
10 | |
5 | |
3 | |
3 |