Forum Discussion
Problem switching from inner desktop measure to analysis services measures
Hi all,
I developped a report connected to Analysis Services on a live connection.
For different reasons, measures were created in Desktop and not in Analysis Services.
I now imported my measures in Analysis Services and want to use them in the report.
However, even if I delete measures created in Desktop, visuals doesn't recongnized my Analysis Services Measures even through they have the same name.
Any idea how to achieve this without reconstructing my visuals ?
Thank you in advance for your help !
Regards,
Alice
Hi, Anonymous
One possible reason for this is that when you create a measure in a .pbix file and then update the Analysis Services model with a measure of the same name, the measure in Analysis Services overrides the measure in the report. The one written in the report will show the error.
To resolve this issue, you'll need to replace the report measure with the model measure in any visual that uses the report measure.
You can check the following link
Solved: Adding Measures in power BI Over SSAS Do they get ... - Microsoft Fabric Community
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi, Anonymous
One possible reason for this is that when you create a measure in a .pbix file and then update the Analysis Services model with a measure of the same name, the measure in Analysis Services overrides the measure in the report. The one written in the report will show the error.
To resolve this issue, you'll need to replace the report measure with the model measure in any visual that uses the report measure.
You can check the following link
Solved: Adding Measures in power BI Over SSAS Do they get ... - Microsoft Fabric Community
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.