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.
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!
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |