Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Oussama
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

thx

2 REPLIES 2
Vicky_Song
Impactful Individual
Impactful Individual

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)

wynhopkins
Most Valuable Professional
Most Valuable Professional

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,

MVP | Author of Power BI for the Excel Analyst | Speaker | Power BI & Excel Developer & Instructor | YouTube- 5 million views | Fan of Power Query & XLOOKUP | Purpose: Making life easier for people through applying and sharing knowledge.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.