Issues with blank measures in Azure Analysis Services and PowerBI Desktop

[geeb]

As the title indicates, I'm having some issues with blank measures when using PowerBI Desktop and Azure Analysis Services. Here are the results I'm trying to get:

This is from Excel => Azure Analysis Services. So far, so good. Note the empty values for Offline Time Tracker Hours (all) in the first three rows and the completely empty column Other Hours - OT. These results are accurate.

When I try replicating these filters in PowerBI Desktop, using the same Azure Analysis Services instance/model, here's what I get:

Looks like the empty row values in the first screenshot were replaced by the left column's values. If I try adding the columns in a different order, I get this:

Really odd. If I deploy the same model to an on-premises VM and connect PowerBI Desktop to that SSAS model, I get the correct results.

To summarize:

Excel => Azure Analysis Services = OK

PowerBI Desktop => Azure Analysis Services = Not OK.

PowerBI Desktop => SQL Analysis Services (onprem) = OK.

Please note that I tried using two PowerBI Desktop versions: one with the latest April update (v2.45.4704.442), and another older version downloaded on February 23 2017. The behavior above happens in both versions.

Any ideas what's going on here? Thanks!

[geeb]

 Not sure if this went through (new user, post awaiting email confirmation). Replying to check instead of double posting.

[v-sihou-msft]

@geeb

We reproduced exactly same issue as you described.

We have reported this issue and opened a ticket internally.

Regards,

[geeb]

Thank you! I'm glad you were able to reproduce it.

[geeb]

As the title indicates, I'm having some issues with blank measures when using PowerBI Desktop and Azure Analysis Services. Here are the results I'm trying to get:

This is from Excel => Azure Analysis Services. So far, so good. Note the empty values for Offline Time Tracker Hours (all) in the first three rows, and the fact that Other Hours - OT is completely empty. These results are accurate.

When I try replicating these filters in PowerBI Desktop, using the same Azure Analysis Services instance/model, here's what I get:

Looks like the empty row values in the first screenshot were replaced by the left column's values. If I try adding the columns in a different order, I get this:

Really odd. If I deploy the same model to an on-premises VM and connect PowerBI Desktop to that SSAS model, I get the correct results.

To summarize:

Excel => Azure Analysis Services = OK

PowerBI Desktop => Azure Analysis Services = Not OK.

PowerBI Desktop => SQL Analysis Services (onprem) = OK.

Please note that I tried using two PowerBI Desktop versions: one with the latest April update (v2.45.4704.442), and another older version downloaded on February 23 2017. The behavior above happens in both versions.

Any ideas what's going on here? Thanks!

[geeb]