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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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
Comments
Anonymous
Not applicable

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