Forum Discussion
Solved
How Data Refresh programmatically?
Is there another way to do a data refresh for a PowerBI report (via PowerShell or Rest API, how to access the Rest API, do we enable this?) I have a query to check what powerBI report has failed,...
lbendlin wrote:
I never know if a question posted in the report server section is actually related to report server. The "catalog" wording should have been my hint to leave this alone as I have no experience with report server.
🙂 it can be hard to tell. A lot of people do not differentiate between "Server" and "Service"
lbendlin wrote:
Is there a way to use the SQL scheduler?
Not easily, the SQL agent jobs are created with Schedule GUID so you are faced with the orignal issue of having to link a ScheduleID and a catalog item
yes to all - plus you can do it via Power Automate. You can even get more granular and refresh individual tables and even partitions.
Enhanced refresh with Power BI REST API - Power BI | Microsoft Learn