Power Automate refresh data connection et TCD on Excel file

Hi francl_lunch ,

Apart from the troubleshooting options correctly suggested by andrewsommer 

You might want to troubleshoot the error that you are getting. It might be because the TCD is not used properly?

Here are the 4 fundamental rules for properly using a pivot table

1.Never in a TCD should you have data already aggregated.
2.Data must be granular.
3.No line of your data should be empty
4.All column headers must be populated with a unique name

Reference-  https://www.excel-exercice.com/en/rules-for-constructing-a-pivot-table/

Regarding Power Automate online:

Refresh is not fully supported in Power Automate
Office Scripts can't refresh most data when run in Power Automate.
Most refresh methods, such as PivotTable.refresh, do nothing when called in a flow.
Additionally, Power Automate doesn't trigger a data refresh for formulas that use workbook links.

You can check

1. Azure Logic Apps-Logic Apps might provide better flexibility, especially for scenarios where you need advanced integrations

Azure Logic Apps

2. Graph API with Power Automate- You can automate the refresh of Power BI datasets by calling specific Graph API endpoints, and this could be done through Power Automate as an HTTP request.

Follow these steps to learn how Graph API works with Power Automate-

https://sharepains.com/2023/01/03/microsoft-graph-api-the-power-platform

Hope this helps!

If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.