Excel Online Refresh

Question

I have a Canvas Power app that is connected to tables in Excel as a data source. I created a separate excel file to create reports using the data gathered form the App. Both the excel spreadsheet that is the data source as well as the file with the report tools are shared on One Drive. The reporitng file is shared with others in the company. When I am attempting to do a Data Refresh of my Power Queries in the excel file it is giving me this error:

Is there a workaround to be about to Refresh Queries in the Excel online version. So far I am only able to do so in my desktop version.

Thanks,

Emmy

Answer 1

Ok, so I didn't realize others could open the file on their desktop if it's saved to One Drive; they have only been able to open the file via online excel. So maybe my question is more... how do I "share" the file so that others can open it on their desktop instead of the online version?

Answer 2

OK that is easy enough.

.

• Save the file in OneDrive (or SharePoint)
• in OneDrive, right click on the file and select Share.
• You then get a dialog like this
  
• If you want to limit access, use the top option to send links to specific email accounts
• If you want the file to be accessible to anyone, pick second option. Then anyone with the link can access the file

Here is the related MS article https://support.microsoft.com/en-us/office/share-onedrive-files-and-folders-9fcc2f7d-de0c-4cec-93b0-a82024800c07

This 2 minute youtube shows how to open files in OneDrive from desktop Excel https://www.youtube.com/watch?v=ZaaLu3-TVzc