Forum Discussion
Scheduling Excel Workbook Connection (Dataflow) Refresh
Hi florianh,
I would like to apologize for my earlier response and the delay in addressing your concerns. I now understand that my previous reply did not fully address your issues. Thank you for your patience and understanding.
After thoroughly reviewing your query and the Microsoft documentation provided, it is clear that Power Automate does not fully support refreshing Excel workbook connections when the workbook is stored online. This presents a significant limitation for your needs. My previous recommendation to use Power Automate was not suitable given these constraints.
- According to Microsoft, Power Automate is unable to refresh most Excel data connections when the workbook is stored on SharePoint or OneDrive.
- Power Query is not supported in Excel Online, which restricts your capability to execute transformations and refresh data within the cloud environment.
- The current viable solutions include utilizing Power Automate Desktop (which necessitates a running computer) or transferring your data transformations and refreshes to Power BI and employing the “Analyze in Excel” feature.
Please provide your valuable suggestions in the Ideas Forum so Microsoft can consider them for future releases.
If this post helps you, please mark it as the solution and give a kudos so that other members of the community can easily find it helpful.
Thank you for being a part of the Fabric Community.
"While Power Query isn’t available in Excel Online, you can still use Power Automate to automate data workflows. "
This is the issue and not the answer!!! here a link from Microsoft saying that it is not possible with Power Automate:
Hi florianh,
I would like to apologize for my earlier response and the delay in addressing your concerns. I now understand that my previous reply did not fully address your issues. Thank you for your patience and understanding.
After thoroughly reviewing your query and the Microsoft documentation provided, it is clear that Power Automate does not fully support refreshing Excel workbook connections when the workbook is stored online. This presents a significant limitation for your needs. My previous recommendation to use Power Automate was not suitable given these constraints.
- According to Microsoft, Power Automate is unable to refresh most Excel data connections when the workbook is stored on SharePoint or OneDrive.
- Power Query is not supported in Excel Online, which restricts your capability to execute transformations and refresh data within the cloud environment.
- The current viable solutions include utilizing Power Automate Desktop (which necessitates a running computer) or transferring your data transformations and refreshes to Power BI and employing the “Analyze in Excel” feature.
Please provide your valuable suggestions in the Ideas Forum so Microsoft can consider them for future releases.
If this post helps you, please mark it as the solution and give a kudos so that other members of the community can easily find it helpful.
Thank you for being a part of the Fabric Community.