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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
davisbizhq
Frequent Visitor

Improved multi-value parameters support for DAX with On-Prem Data Source

Some time last September it was announced that there was "Improved multi-value parameters support for DAX" to prevent the problem described by Chris Webb in this blob post.  We're using an on-prem SQL Server Analysis Services tabular model and executing some embedded paginated reports against the model, and I'm hitting that very problem where the RSCustomDaxFilter is rendering too large a DAX query.  The improvements, according to the author, "changed how we handle this in product and most users should no longer see this error."  I deployed our tabular model to AAS, tested it, and sure enough -- it is resolved in the cloud.

 

Does anyone know whether there are any plans to update the on-prem data gateway and/or SSAS in order for that benefit to apply to us as well?

1 REPLY 1
v-deddai1-msft
Community Support
Community Support

Hi @davisbizhq ,

 

Not very sure. But you can create an idea for it in 

https://ideas.powerbi.com/forums/265200-power-bi-ideas to improve the power bi.

 

Best Regards,

Dedmon Dai

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors