How to skip the tables in Power BI

[adarshthouti]

I have various types of datasets where certain tables may be present at times but absent at other times.

For instance, consider a scenario with monthly sales data. In some months, additional tables like customer feedback or product returns might be included alongside the sales data, while in other months, these tables may not exist.

Is there a dynamic approach in Power BI where the tool can load the data if the tables are present and skip them if they are absent?

I want the PBIX file to dynamically understand and adapt to the presence or absence of these tables within the datasets.

For example, my dataset is in XER (XML Encoding Rules) format. In one dataset:

a) I have a set of tables like SALES, EMPLOYEE, GROSS, and NET.
b) In another dataset, I only have SALES and GROSS.

In this above case, I want to skip the EMPLOYEE and NET tables whenever I load the data, with the help of parameters, and unskip them when they are present."

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but in my opinion, the starting point might be knowing the infromation of the tables in each semantic model.

Please check the link down below, and there is one of many useful DAX functions, INFO.TABLE DAX function.

DAX query view introduces new INFO DAX functions | Microsoft Power BI Blog | Microsoft Power BI

[adarshthouti]

For example, my dataset is in XER (XML Encoding Rules) format. In one dataset:

a) I have a set of tables like SALES, EMPLOYEE, GROSS, and NET.
b) In another dataset, I only have SALES and GROSS.

In this above case, I want to skip the EMPLOYEE and NET tables whenever I load the data, with the help of parameters, and unskip them when they are present.