Refresh Excel Workbook published automatically on demand

Hi Anonymous ,

There are a few ways you can refresh the Excel data connected to a CSV file on Sharepoint in an automated way:

• One option is to use the Power BI API to refresh the data. You can use the API to trigger a refresh of the data in your Power BI dataset, which will update the Excel file with the latest data from the CSV.
• Another option is to use Power Automate (previously known as Microsoft Flow) to set up a flow that will trigger the data refresh when the CSV file is updated. You can set up a flow that monitors the Sharepoint folder where the CSV file is located, and when it detects a change to the file, it will trigger the data refresh in Power BI.
• Alternatively, you can use the Power BI REST API to refresh the dataset. You can use the API to refresh the dataset on demand, or you can set up a scheduled refresh to regularly update the data at a specific time.

It's important to note that in order to use the Power BI API or Power BI REST API, you will need to have a Power BI Pro license. If you don't have a Power BI Pro license, you can still use Power Automate to trigger a data refresh, but you will need to have a Power Automate license.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.