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

[RCL1006]

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?

In Power BI Desktop

In Excel

[RCL1006]

@saud968 @v-huijiey-msft 
Hi Both Expert

Thanks for suggestions, And I try before asking

Maybe I provide question not enough.

I want to no show “Unknown” value in “Filters on this visual”.
Because it's show “Unknown” value in “Filters on this visual” then End-User any who must be confuse in this condition.

[saud968]

Here are a few steps you can take to hide the "Unknown" value in the "Filters on this visual" section in Power BI:

Create a Measure: You can create a measure to filter out the "Unknown" value. For example:

FilteredMeasure = IF([YourColumn] = "Unknown", BLANK(), [YourColumn])
Then, use this measure in your visual instead of the original column.

Use Visual Level Filters: Apply a visual level filter to exclude the "Unknown" value. In the Filters pane, add a filter condition to exclude "Unknown":

Select the visual.
In the Filters pane, drag the field you want to filter on.
Set the filter condition to exclude "Unknown".
Adjust Data Model: Ensure that your data model in Power BI respects the hidden settings from SSAS. Sometimes, re-importing the data or refreshing the dataset can help.

Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!

[v-huijiey-msft]

Hi @RCL1006 ,

Thanks for the reply from saud968 .

You can hide Unknown Members in Power BI desktop by following these steps:

Select your Slicer.

Uncheck the “Unknown” value in “Filters on this visual”.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[saud968]

1. Verify SSAS Cube/Tabular Model Settings:

Check Dimension Properties:
In SSAS Management Studio, navigate to the Dimension you're working with.
In the Properties window, locate the "Unknown Member" property.
Ensure it's set to "Hidden" as intended.
Check Attribute Hierarchies:
If you're using hierarchies within the dimension, ensure the "Unknown Member" property is also set to "Hidden" at the hierarchy level.
2. Power BI Desktop Data Source Settings:

Refresh Data Source:
Right-click on the data source in Power BI Desktop and select "Refresh." This ensures the latest metadata from SSAS is loaded.
DirectQuery vs. Import:
DirectQuery: If using DirectQuery, changes in SSAS metadata should be reflected immediately. However, there might be a slight delay in some cases.
Import: If using Import, the data is cached locally. You might need to refresh the data in Power BI Desktop to see the changes from SSAS.
3. Power BI Desktop Model:

Check Calculated Columns/Measures:
Examine any calculated columns or measures that might be interacting with the dimension.
If they are explicitly referencing the "Unknown Member," modify them to handle it appropriately.
Check Filters:
Verify that any filters applied to the dimension in Power BI Desktop are not explicitly including the "Unknown Member."
4. Power BI Desktop Visuals:

Check Visual Filters:
Inspect the filters applied within the specific visuals where the "Unknown Member" is appearing.
Ensure the filters are not unintentionally including or highlighting the "Unknown Member."
Check Visual Level Filters:
If using visual level filters, make sure they are not interacting with the dimension in a way that displays the "Unknown Member."
5. Troubleshooting Steps:

Create a Simple Model:
Create a very basic Power BI Desktop model with just the problematic dimension.
This can help isolate whether the issue is specific to your current model or a more general problem.
Test with a Different Data Source:
If possible, try connecting to a different data source (e.g., another SSAS cube or a different data source altogether) to see if the "Unknown Member" still appears. This can help determine if the issue is specific to your SSAS cube.
Check for Custom Members:
If your dimension has custom members, ensure they are not interacting with the "Unknown Member" in unexpected ways.
6. Restart Power BI Desktop:
* Sometimes a simple restart of Power BI Desktop can resolve unexpected behavior.

Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!