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.
definitely not solved yet. Would be really helpful if power query would be supported by excel online, then I could solve it with power automate.
Hi florianh,
Thank you for your follow-up question! Currently, Power Query is supported in Excel Desktop but has limited functionality in Excel Online.
However, there are a few workarounds you can consider:
- Please perform your data transformations using Power Query in the desktop version of Excel. Additionally, save the file to OneDrive or SharePoint to ensure it syncs with Excel Online. The transformed data will be accessible in Excel Online; however, please note that you will not be able to edit the Power Query steps there.
- While Power Query isn’t available in Excel Online, you can still use Power Automate to automate data workflows.
- Import data from various sources like SharePoint, SQL into Excel Online. Conduct basic data manipulations using Excel formulas or scripts and then export or further process the data as needed.
If this post has helped you, accept it as the correct solution so other members can find it quickly.
Hope this helps!
Thank you.
"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.