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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply

Power BI auto-hides visible tables with all columns hidden (bug)

I have a client who's trying to publish a table that's visible, but only has a single column that's hidden.

 

He's trying to have a table with no existing measures (called Report Measure) that's an anchor point for report designers to attach their report-specific measures. 

 

All other tools show the table but Power BI Desktop automatically hides a table that has no visible columns.

 

This seems like a bug.

2 REPLIES 2
paakow_pbiuser
Regular Visitor

paakow_pbiuser_0-1664266319007.png

Have the same issue with the above version of PBI Desktop connecting to SSAS 2017 (tabular model database in 1200 compatibility). We have a few tables where a handle full of columns is hidden, but PBI Desktop hides the entire table. Strange though the Sep 2021 RS PBI Desktop version doesn't behave this way and correctly shows the table(s) with only the visible columns available.

 

 

 

I should add that this is a tabular model in Azure Analysis Services, accessed via Live Query.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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