Only load table to sheet if condition met

[Anonymous]

I have a table in power query called ElementHeaders which I only want to load to a sheet if a checkbox on a sheet called Settings has been checked.

Is this possible? I can find nothing on how this might be done.

Thanks

[v-yalanwu-msft]

Hi, @Anonymous ;

If I understand correctly, you mean that you want to load tables that meet the conditions, and those that do not meet are not loaded into desktop, right? If so, you can try using the Parameter function; This function can be dynamically filtered, which can be seen in the following blogs and official documents:

Dynamic Filtering Using Parameters in Power BI - Perficient Blogs

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

If not, can you share more details?

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.