cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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

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

7 REPLIES 7
Highlighted
Super User IV
Super User IV

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

Hi there

Could I ask what you mean by Underline export?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Highlighted
Microsoft
Microsoft

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

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.

Highlighted
New Member

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

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

Highlighted
New Member

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

Highlighted
Microsoft
Microsoft

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

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.

Highlighted
New Member

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

hi @v-yingjl 

 

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

Could you please raise this again?

 

Thank you

Highlighted
Microsoft
Microsoft

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

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

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors