Forum Discussion
PARAMETER TO LOAD TABLES
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
4 Replies
The information you have provided is not making the problem clear to me.
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
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.
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:
- parametrize data source to connect to different servers and different databases
- Load column values dynamically
- Filter rows / data
- Replace values
You can also refer the following documentations for the details.
https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/
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
