PARAMETER TO LOAD TABLES

[santiagomur]

Hi, 

i am try to created a theme, i already have some parameters to load tables but now i need a parameters yes or not to load the table example:

table 1

yes or not

table 2

yes o not 

i try using not then a date that generate an empty table but the table is load i can see the table on the fields 

[Anonymous]

Hi @santiagomur ,

I'm sorry I can't understand your needs. Could you please provide more details to supplement explanation? Some example data and your expected results are required.

Best Regards

Rena

[santiagomur]

hi @Anonymous 

i try to made a template with some parameter as filters, so i need to load 2 different tables but not always so some user only need 1 so what i do is to parameter table 1 parameter yes or no parameter table 2 yes or no if you say no what is bring the table empty, but i still bringning the table now i whant that when you say no on the parameter the query dont run or a step to hide the table. 

[Anonymous]

Hi @santiagomur ,

Do table 1 and table 2 come from different data sources? If so, you can use query parameter to parametrize the data source. Query parameter can be created to use in the following cases:

1. parametrize  data source to connect to different servers and different databases
2. Load column values dynamically
3. Filter rows / data
4. Replace values

You can also refer the following documentations for the details.

https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

https://www.red-gate.com/simple-talk/sql/bi/power-bi-introduction-working-with-parameters-in-power-b...

In addition, the user can use the " Enable load " option to control whether the data in table 1 and table 2 would be loaded into the model or not if both of table 1 and table 2 are loaded.

Best Regards

Rena

[amitchandak]

The information you have provided is not making the problem clear to me.