Forum Discussion

simp's avatar
simp
Icon for Helper I rankHelper I
8 years ago

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...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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 

simp's avatar
simp
Icon for Helper I rankHelper I
8 years ago

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