cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Salonic
Resolver I
Resolver I

Create Measure on MDX SSAS Cube

On our environment we have a cube SSAS MDX on-prem.

We know that it is not possible to create measure on this cube ... directly ..., but we manage to do it when publishing an empty powerbi file and connecting a desktop to the dataset from powerbi.com of that file.

Meaning :

Power BI Desktop => Cube MDX SSAS Prem => Not possible to create measures

Power BI Desktop => Live MDX Dataset on powerbi.com => Cube SSAS Prem => Possible to create measures

 

With the version of March 2021, we saw that this functionality has been blocked.

What is weird is that if we open a file created with an older version, we see the measures that have been created and we even have the possibility to edit them... but we can not create new ones.

A solution would be to create lot of measures ( ~ 50 measures ) on an older version and edit those measures on newer version.

 

 

Does anyone facing the same issue ?

I do not understand why this functionality is blocked (measures on live query MDX SSAS), does someone has an explanation ?

 

6 REPLIES 6
IsabellaBj
Frequent Visitor

Hi there,
How are you managing with this problem? I am experiencing the same problem since the March update (the only difference is I am using tabular rather than MDX). My Power BI desktop has now updated to the April version, but the problem still persists unfortunately. Very thankful if anyone has any pointers on how to resolve this.

Kind regards,
Isabella

Hello,

 

Same for me : I updated with the lastest version (April 2021) still facing same issues which has a major impact on most of my reports ...

I believe the only way to solve this issue is to vote for this :

https://ideas.powerbi.com/ideas/idea/?ideaid=0ee95af7-ec10-464a-8146-114f91e653c9

And wait for Microsoft to change a variable in the source code of powerbi desktop and make things work again.

 

v-henryk-mstf
Community Support
Community Support

Hi @Salonic ,

 

According to my test, after installing the latest version of powerbi desktop from the official website and connecting to the SSAS Cube data source, the report level measure can be created based on the data source in the desktop. Please try according to the above description.

If your problem is still not solved, please let me know in time and provide a screenshot of the specific test steps. I will answer you as soon as possible.

v-henryk-mstf_0-1618203523769.png

download from here

 

Looking forward to your reply.

Best Regards,
Henry

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

Hello,

 

Thank you very much for your reply !

 

Where did you get the April version ?
I just downloaded the last powerbi desktop version and it is March 2021 version :

https://www.microsoft.com/en-us/download/details.aspx?id=58494

 

 

 

Hi @Salonic ,

 

The latest version downloaded from the official website is in March, and what you downloaded is correct. I use @microsoft.com to log in to the internal beta version downloaded from the MS Store, so the update shows April. Both are not the same.😁

v-henryk-mstf_0-1618384984743.png

 


Best Regards,
Henry

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

 

Thank you for your quick reply !!

 

So for the moment I can not check if this solves my problem ... 😞

Do you know when April version will available for everyone ?

 

Helpful resources

Announcements
Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!

#PowerBIWomenSummit

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!