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 want to access to specific table on a shared folder file,
This is my query:
Excel.Workbook(File.Contents("\\ipaddress\folder\subfolder\filename.xlsx"), null, true) {[Name="SheetE"]}[Data]
Everything is OK until I add data validation List in "SheetE" from named range in "SheetJ"
The query become running to other sheets that i dont want to access...
Before i add a data validation List it only access to SheetE
Hope PBI Team can fix it, because it effect to query performance
Hi @simp,
As you referenced to SheetJ in SheetE, Power Query will creating connection to SheetJ during execution. In your scenario, is there existing any relationshipt between SheetJ and other sheets?
Regards,
Yuliana Gu
There is no relationship between sheets
Here is the screenshot, you can see that the query is also reading to other sheets
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 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |