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.
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!
Not sure if this went through (new user, post awaiting email confirmation). Replying to check instead of double posting.
We reproduced exactly same issue as you described.
We have reported this issue and opened a ticket internally.
Regards,
Thank you! I'm glad you were able to reproduce it.
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!
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |