Report Builder - No DAX Query design mode

[SivaMani]

Hi All,

I'm unable to run/edit reports which are using DAX queries. I don't have any option to switch MDX to DAX in Query Designer.

Please do assist me!

[dax · Accepted solution]

Hi SivaMani,

In Report Builder, I could switch MDX to DAX,  but it will lost the content when transform, so you need to write DAX query manually.

You said that you can't run and edit the report which write with DAX, what error did you get? What is your report builder version(Please note that the ability to use the query designer for DAX is limited to SSAS tabular data sources built in 2016+ only.)? You could refer to Query designer support for DAX now available in Report Builder and SQL Server Data Tools  for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.