Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Power Query in Excel different from Power Query in Power BI

Hello everyone! I mainly use Power Query in Power BI and recently in Excel. I noticed some differences between these two "versions" of Power Query (in the M language, for instance). It looks similar to what @vpatel55 is experiencing in his post. Recently, I noticed a blocking difference: in PQry for PBI, I can access all the files of a SharePoint site library. If I do the same operation with PQry in Excel, some folders are invisible and inaccessible even though sub-folders of those invisible folders are visible. Have you ever had this experience? Do you know the cause and solution to this weirdness? Thanks for your help!


You should not post the same question on 2 different forums. It is disrespectful to those who answer questions, only to find out that you have already got the answer somewhere else. 

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors