Share via

SSAS Hidden "Unknown Member" But Still Show On Power BI

LRC1006 20 Reputation points
2025-01-15T09:13:45.1266667+00:00

Hi Expert

It's setting Unknown Member "Hidden" for every dimensions on SSAS, and it's display normal on excel 2016 above, but on the Power BI still show "Unknown" in dimensions.

Can anyone who will solve it?

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,307 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 39,671 Reputation points
    2025-01-16T07:56:23.7766667+00:00

    Hi @LRC1006,

    Here is a same issue, you may take a reference to.

    https://community.fabric.microsoft.com/t5/Desktop/SSAS-live-connection-Slicer-shows-values-with-no-data-unknown/m-p/33739

    If this does not work, you may also raise the issue to the PBI community to get more professional advice there.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.