Forum Discussion
Exporting Data From Online Missing Columns
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
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
3 Replies
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