Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Does PQ allow disable load table ?

Hi All   Does PQ allow disable load table ?  'My PBI File load 6 table. may I know how to set PQ only load 4 table ? Set temperay load only 4 table.   So that I can have 1 file for 2 company. ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Yes.  If you uncheck that, it won't load.  Note there is a different option there to include in refresh.  So tables that are not loading can still be refreshed as part of refreshing queries that are loaded.

     

    Regards,

    Pat

     

  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi Anonymous ,

     

    So your issue is solved now,right?

    If so,could you pls mark the reply as answered to close it?

     

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Sir

 

May I know how to load selected table ? 

can I have the screen shot where to set ?

 

Paul

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

You can right click on a query and uncheck Enable Load.  That way, you can still use a query to make another query and not have to load both.

 

Regards,

Pat

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi MAHONEY

     

    Thank you very much . This is what I look for..

    May I know if I never tick enable look , does it mean that particular table will not be load into PBI ?

    • mahoneypat's avatar
      mahoneypat
      Icon for Microsoft Employee rankMicrosoft Employee
      5 years ago

      Yes.  If you uncheck that, it won't load.  Note there is a different option there to include in refresh.  So tables that are not loading can still be refreshed as part of refreshing queries that are loaded.

       

      Regards,

      Pat

       

    • v-kelly-msft's avatar
      v-kelly-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi Anonymous ,

       

      So your issue is solved now,right?

      If so,could you pls mark the reply as answered to close it?

       

       

      Best Regards,
      Kelly

      Did I answer your question? Mark my post as a solution!