Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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,
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
108 | |
108 | |
108 | |
90 | |
61 |
User | Count |
---|---|
171 | |
138 | |
132 | |
102 | |
86 |