Forum Discussion

JamesDenman's avatar
JamesDenman
New Member
2 years ago

Power Query not working in Excel Online

According to MS, it should be possible to update PQ queries in Excel Online: https://support.microsoft.com/en-us/office/use-power-query-in-excel-for-the-web-02652946-de70-48d8-8a34-3db96998ff5a   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi JamesDenman ,

 

I tested it by logging into OneDrive using my organization account and found that it refreshes properly.

 

I can't sign in to OneDrive with personal account because of some policy. if possible could you try signing in to OndDrive with your organization account and try again?

 

Thread on the same topic:

Power Query queries in Excel for the Web can’t be refreshed in - Microsoft Community

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

JamesDenman's avatar
JamesDenman
New Member
2 years ago

Hi Gao Anonymous ,

 

Thanks for the good test. As described above, I'm using a Microsoft 365 Family licence - that's the only account available to me, so I can't sign in with an "organization account".

 

Does this mean that Excel Online behaves differently depending on whether the file is saved in a OneDrive location for a user with a non-organization M365 licence vs. a OneDrive location for a user with an organization M365 licence?

 

Best regards,

 

James