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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors