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.

now I need to create 2 PBI file . One load 6 table , another load 4 table 

 

Paul

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!

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous I didn't get you correctly, but if you want to load selected table in Power BI, you can do so at the time of data loading or you can delete the unwanted table in Power Query.

    • 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
        Microsoft 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