Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
7 | |
4 | |
3 | |
2 | |
1 |
User | Count |
---|---|
7 | |
6 | |
6 | |
4 | |
3 |