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

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

Reply
greglow
Most Valuable Professional
Most Valuable Professional

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.

 

 

 

greglow
Most Valuable Professional
Most Valuable Professional

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

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.