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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

0

'Show values of the selected field' option of Field Parameters not available for Composite Models

Hello,

 

I'm encountering an unexpected behaviour while connecting with Direct Quert to Power BI dataset and creating local (composite) model from it.

 

'Show values of the selected field' option of Field Parameters when they are used within a slicer (blog announcment) is not available anymore.

 

If I'm connecting directly via DQ to PBI dataset this option works fine, it stops working when clicking 'Make changes to this model' on lower bar next to Storage Mode information. As soon as I make this change, slicer with this option breaks and the error is generic "Something's wrong with one or more fields". If I try to set this up while already being in Composite model mode this option is not available in context menu.

 

I realise that Field Parameters are preview feature, but is this expected behaviour? It is not described as limitation in documentation.

Status: Delivered

Hi  @WindFarmer ,

 

The following limitations apply when working with DirectQuery for Power BI datasets and Analysis Services:

  • Parameters for database and server names are currently disabled.

Use composite models in Power BI Desktop - Power BI | Microsoft Learn

 

Best regards.
Community Support Team_ Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Delivered

Hi  @WindFarmer ,

 

The following limitations apply when working with DirectQuery for Power BI datasets and Analysis Services:

  • Parameters for database and server names are currently disabled.

Use composite models in Power BI Desktop - Power BI | Microsoft Learn

 

Best regards.
Community Support Team_ Caitlyn