Forum Discussion
Does PQ allow disable load table ?
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
Hi Anonymous ,
So your issue is solved now,right?
If so,could you pls mark the reply as answered to close it?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
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.
Hi Sir
May I know how to load selected table ?
can I have the screen shot where to set ?
Paul
- mahoneypat
Microsoft Employee
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
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
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 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