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.
I am trying to connect to an SSAS cube with powerBI desktop...The connection doesn't work when the cube contains a calculated member with no data on the cube (empty tuple).
Does any one have a workaround ? I don't want to replace Empty value by a zero
thx
I'm afraid there is not one method to import empty value of one dimension calculated member into Power BI.
Reference from the Supported Features of SSAS MD in Power BI Desktop part of this article:
Support features of SSAS MD:
For Dimension Calculated Members (must be a single real member when the dimension has more than one attribute, it cannot be the key attribute of the dimension unless it is the only attribute, and it cannot be a parent-child attribute)
I have worked around this by setting up an empty table with the same column headings as the SSAS query would return if there was data. I then append my SSAS query to the empty table. Seems to work,
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 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |