Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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,
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |