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.
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
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.