Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
AndySmith
Helper III
Helper III

Tabular Editor - Field Parameters - fields from more than 1 table

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?

 

 

1 REPLY 1
DataNinja777
Super User
Super User

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,

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.