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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.