Nov 03 2021 05:12 PM
I have an Excel file that I wand to be able to do a Data -> Refresh All Connections to update a very simple Power Query script. I have 4 Excel Sheets and a simple Table in each. I have a Power Query script setup to import each table them Append all 4 tables then put the Table on another sheet filtering out NULL. Unfortunately when doing a Refresh online instead of the desktop I get the error message “External Data Refresh Failed – We were unable to refresh one or more data connections in this workbook. The following connections failed to refresh.”
I only a found a few very old references to this issue and was hoping someone had a suggestion. In my mind it is not even an External connection as everything is contained in a single sheet. I know Excel desktop sometimes says it is an External connection also if not in a trusted folder. However it seems like there should be a way for this to refresh on the web if all internal to the same file.
Any help thoughts or workarounds?
Thanks
Alan
Nov 04 2021 12:24 AM
@Alan Jones As far as I know, you can NOT refresh PQ queries in Excel for the web. You can see that the file contains queries but you can not create, review, edit or refresh them.
Nov 04 2021 06:08 AM
In addition about error message. Excel for web currently could refresh external connections. These are PivotTable connections to Power BI dataset, data model or cache. They are all external.
If Excel tries to refresh Power Query it looks for external connection for it, finds nothing and returns such error.
At least that's my understanding.
Nov 04 2021 08:53 AM
Nov 04 2021 08:53 AM
Nov 04 2021 10:02 AM
Hope it's coming
Jun 13 2022 12:36 PM