Forum Discussion
Exporting Data From Online Missing Columns
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
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
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...
Yes, if you would like to see all the columns when you exporting the data, You must chnage the data type as text