Forum Discussion

igaca's avatar
igaca
Icon for Helper III rankHelper III
10 years ago
Solved

Prevent Query From Loading into PBI Desktop "Data" view from Query Editor - Is this an option?

Does not appear to be an option at this point in time (like it is in excel). I am working with 25 or so large excel files and "Excel.Workbook([Content])" results were unsatisfactory due to slight va...
Need Help
  • Habib's avatar
    Habib
    10 years ago

    Hi igaca

     

    In Query Editior rith click on the query you want to to hide in data view and uncheck Enable Load. This way, query connection will remain in the PBI but query will not be loaded in data view and report view.

     

    Please refer to below image.

     

     

Habib's avatar
Habib
Icon for Continued Contributor rankContinued Contributor
10 years ago

Hi igaca

 

In Query Editior rith click on the query you want to to hide in data view and uncheck Enable Load. This way, query connection will remain in the PBI but query will not be loaded in data view and report view.

 

Please refer to below image.

 

 

  • igaca's avatar
    igaca
    Icon for Helper III rankHelper III
    10 years ago

    Silly mistakes are great for they are hard to forget :)

    I somehow overlooked that...thanks for setting me straight Habib, I appreciate the prompt reply.

     

    Cheers,

     

    Igor