Exporting Data From Online Missing Columns

[Anonymous]

Hi All,

I am trying to export data from my online dashboard. It is quite a large dataset, consisting of 409 columns and 34000 rows. However when I export the data from a visual online, and select 'underlying data', the resultant output only has 273 columns. The row count seems ok. Does anyone know why this is? Or of any potential fixes?

Thanks,

Zakk

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

If the dataset owner set some certain columns to "hidden", they won't show up in the Field list in Desktop and Power BI service. When you export underlying data from a visual, the resultant output won't contain those hidden columns even they are existing in visual.

When using the “export underlying data” option in Power BI Service, the export file will contain columns which are used to create the visual together with all “Text” type columns. So, if those missing 273 columns are non-text, they won't be exported. You would need to set the rest columns to be “Text” type  or include them in your visual.

Besides, please check whether you hit any limitation of data export.

Best regards,

Yuliana Gu

[Anonymous]

I guess this means setting everything to text in the tab modelling?

But what will happen to my datehierarchies and such when I set all to text?

I have som measures that are shown as percentages. Do I need to those to text as well?

I am sincerely confused here...

[Anonymous]

Yes, if you would like to see all the columns when you exporting the data, You must chnage the data type as text