The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi
Is it only possible to add fields from one table to create parametrs via Tabular Editor? In Analysis Services connected to a date warehouse I have various dimesnions which I would like to be selectable (customer, state, channel, salesperson etc). I have tried using the C# script posted by Daniel Otykier however seems it is limited to selecing fields from 1 table only. Is this correct?
Hi @AndySmith ,
In Tabular Editor, it is indeed possible to create parameters (field parameters) that pull fields from multiple tables. While the default functionality in Tabular Editor typically limits the creation of parameters to a single table at a time, you can work around this by creating a custom C# script that references fields from multiple tables in your model.
If Daniel Otykier’s script appears limited to one table, you may need to modify it slightly. Instead of referencing fields from just one table, adjust the script to include fields from multiple tables by specifying each table and its fields explicitly. For example, in your C# script, you could define an array or list of tables and loop through each one, adding the fields you need for the parameter.
Best regards,
User | Count |
---|---|
24 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
31 | |
12 | |
10 | |
10 | |
9 |