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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

0

Field Parameters Convert to Regular Tables When Live Connecting to a Semantic Model

When I live connect to a semantic model in the Power BI service, my field parameter tables show up. However, they are converted to regular tables and seem to lose their field parameter feature.

 

i.e. - When placed as the x-axis on in a chart, it no longer works as a field parameter.

 

Please see below forum post for reference:

Re: Field Parameters When Live Connection to Seman... - Microsoft Fabric Community

Status: Delivered
Comments
Anonymous
Not applicable

Hi @kewaynes ,

 

You can't create parameters in live connection data sources without a local model. However, if you use DirectQuery for Power BI semantic models and Analysis Services, you can add a local model to create field parameters. For more information about using DirectQuery for live connections, see Composite models on Power BI semantic models and Analysis Services.

 

For more you may see:Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

 

As a workaround,you may refer to :

Solved: Field Parameters Equivalent with Live Connection - Microsoft Fabric Community

Solved: Using Parameters on PBI desktop with a Live Connec... - Microsoft Fabric Community

 

Best regards.
Community Support Team_Caitlyn