Forum Discussion
over acting query
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] Eve...
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
Hi v-yulgu-msft
There is no relationship between sheets
Here is the screenshot, you can see that the query is also reading to other sheets