Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

SSAS Empty Tuple

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


Vicky_Song Impactful Individual
Impactful Individual

Re: SSAS Empty Tuple

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)

Re: SSAS Empty Tuple

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,

Helpful resources

New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors