Forum Discussion
Refresh report data using REST API
Hey,
Yes,whenever you publish a report a dataset gets craeted along with it
Since your source is present within a vnet, in order for your report to referh in power BI service (cloud), you need to set up a gateway between your datasource Vnet and powerbi cloud which is on premises gateway
Hey NandanHegde , we are currently consume the data by:
Get Data -> MySQL databae -> Connect -> Credentials -> Connect -> Navigator -> Select Tables -> Load
To refresh the Data we simply clicked "Refresh" and the new data would be introduced to the report.
We wish to automate the above proccess and could be wrong about the whole approach...
Hey, The above manual approach you are suggesting is being done in your local system via PBIX file refresh.
You need to publish the report to Power BI service post which you can leverage REST APIs to automate the refresh as stated in above blog.
NandanHegde , Yes, we did publish the report. It is available online and can be accessed externally by anyone with a link to that report.
I just can't figure out the equivalent API method to trigger that refresh functionality, if such a thing even exists, we don't use a "DataSet" object. How can I trigger a refresh in this case?EDIT:
NandanHegde , Well, it seems like there is a dataset which I wasn't aware of that is being created after publishing a report. But this dataset has to be configured to get the data via an On-premises Gateway in order to refresh using the API.Hey,
Yes,whenever you publish a report a dataset gets craeted along with it
Since your source is present within a vnet, in order for your report to referh in power BI service (cloud), you need to set up a gateway between your datasource Vnet and powerbi cloud which is on premises gateway