Power BI Service allows to export only text columns in underline data export functionality

[ievgenii]

We have just noticed that not all columns are exported in excel file when we do 'underline export'.
As it was discovered the issue is related to datatype. In exported file we have only those columns which have text datatype., all others are missed.
We didn't find this limitation on https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data

Is it any solution for this (of course expect converting columns data type into text)?

Thanks

[v-yingjl]

Hi @ievgenii ,

Based on my research, 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. If you want to export all columns, you would need to set the rest columns to be “Text” type  or include the rest columns in the visual.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[bamalburg]

Why is this workaround required? Why can't Power BI Service just export all columns in the underlying data, regardless of what data type they are...?

[ievgenii]

hi @v-yingjl 

Thanks for answer! 

Could you please refer to official documentation? 

I couldn't find it in https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#limitations-and...

Thank you

[v-yingjl]

Hi @ievgenii ,

Actually there is no specific limitation about this in the official document, but this is once an internal feedback ticket that has been mentioned. Also, I will sumbit it to my teams again to confirm and thanks for your reflect to help us improve power bi.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[ievgenii]

hi @v-yingjl 

I'll be good to receive udpated information on this topic.

Could you please raise this again?

Thank you

[v-yingjl · Accepted solution]

Hi @ievgenii ,

Surely. After confirmed with my teams, I will raise it and if there is some latest information about it I will update .

Best Regards,
Yingjie Li

[GilbertQ]

Hi there

Could I ask what you mean by Underline export?

[ievgenii]

hi @GilbertQ 

I mean this one https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#export-underlyi...

thanks