Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I created some queries in PQ in Power BI desktop. The query is to a sharepoint folder of excel files, filters results and then pulls in the data from those filtered excel files.
I then copied and pasted the all the Queries and Query Folders (queries, help queries, paramters, sample query, etc.) from PBI to Excel. In total, I copied over 6 query groups. Of those, 4 worked as expected, but then the 5th and 6th queries returned errors, saying that the table of data could not be found.
In looking into the queries, it seems that PBI queries can find the folder and the files but Power Query in Excel cannot. Please see the snap shot. Literally everything is exactly the same in terms of query, code and links.
Any ideas? Please help.
Solved! Go to Solution.
Hi @Doodle
Your question is out the scope of power bi, Please kindly raise your question to power query | excel forum for better advice:
https://www.myonlinetraininghub.com/excel-forum/power-query
Hi @Doodle
Your question is out the scope of power bi, Please kindly raise your question to power query | excel forum for better advice:
https://www.myonlinetraininghub.com/excel-forum/power-query
Noted thanks. Moved the question to Power Query forum here:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |