Strange behaviour for "Show Data" with Table Visualisation

[michaelstone]

Hi all,

We are using Table visualisations to display tabular data and by default, there is a "Show data" menu item for the table.

When I click it, I get another table where all of the dimensions are joined together with comma separation and the measures are provided with separate columns as per the example below.

This is even worse when the table has an Image URL column as it is now displaying the image not found icon as the concatenated dimensions are not a valid URL.

Does anyone know how to disable the "Show Data" menu item for tables?

Is this a bug I should be reporting to Microsoft?

Thanks,

Michael Stone

[V-pazhen-msft]

@michaelstone 

Current there is no such option to disable Show data. I suggest you take a look at the limitations:

Use See Data and See Records in Power BI Desktop

You can also submit an idea for disabled these feature.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/filters/top

Paul Zheng

[Mann]

Hi @michaelstone 

There is no way to disable show data option in Power BI. Check this:

https://community.powerbi.com/t5/Service/How-to-disable-the-See-Records-Show-data-option-in-the-Visu...

You can turn off "Visual Headers" going to settings of Table Visual. This would disable right top ellipses option coming on visual in Power BI services. But one could still go to Show data option by right clicking on the chart.

Mann.