Forum Discussion
Dataset Refresh in Power BI
Hi all,
I am new to Power BI, Kindly help me with script and steps need to follow for refreshing DataSet. i tried using the API, i am looking to automate it in a way when i ran the script it should refresh the dataset.
i have gone through few powershell script. i am failing to install the module. kindly help me on it
6 Replies
Hi Anonymous ,
You could refer to this blog about API:
https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/
To trigger refresh for a dataset in the Power BI service, simply make the following HTTP Request. You can craft this request using an HTTP utility like Fiddler, or by running our sample code.
Some additional tips:
- Once you make the request, a data refresh will immediately be kicked off in the Power BI service
- This works for any dataset imported to the Power BI service that you own
- To get the group ID and dataset ID, you can make a separate API call, or simpler yet, just navigate to dataset settings in Power BI. The URL will have both the group ID, and the dataset ID.
- Like all requests to the Power BI REST API, you will have to attach an AAD access token. For more information, see the Power BI REST API authentication documentation.
thanks for the response. The sample code you mentioned if i schedule in task manager to run will refresh kickoff without any prompt for entering password??
and what are the prerequists to test, should i need to install any modules. i tried it once its throwing an error and how to send mail if failure occurs. kindly help me on this.Hi Anonymous ,
I recommend you to follow the tutorial of API.
https://docs.microsoft.com/en-us/power-bi/developer/walkthrough-push-data
And there are some tools necessary to you.
