Forum Discussion

simp's avatar
simp
Helper 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]

 

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

 

 

 

Need Help

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft 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
      Helper 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