Does PQ allow disable load table ?

[Paulyeo11]

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

[mahoneypat · Accepted solution]

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

[Anonymous]

@Paulyeo11 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.

[Paulyeo11]

Hi Sir

May I know how to load selected table ? 

can I have the screen shot where to set ?

Paul

[mahoneypat]

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

[Paulyeo11]

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 ?

[v-kelly-msft · Accepted solution]

Hi @Paulyeo11 ,

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!

[mahoneypat · Accepted solution]

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

[Anonymous]

@Paulyeo11 Here for example, in my excel, I have multiple sheets, but if I don't want to load all the tables, I would just select those which I want-

You would get this window when you do get data