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!
Forum Discussion
Power Query in Excel different from Power Query in Power BI
1 Reply
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.
