Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
munnaz
Frequent Visitor

Extra columns in export created by "-"

Hi Gurus,

 

When exporting a table from desktop to excel, new colomns appear to be created by cells with the character "-" which excels treats as a tab or new coloumn? Eg I have a PBI table with 10 columns but when exported to excel appears as 13. Any ideas how to fix this?

 

I've tried pasting special as unitext or text but didn't make any difference.

1 ACCEPTED SOLUTION
VahidDM
Super User
Super User

Hi @munnaz 

 

You can use Dax Studio and easily export each table to Excel 

https://daxstudio.org/

 

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

Appreciate your Kudos!! 

 

LinkedIn|Twitter|Blog |YouTube 

View solution in original post

3 REPLIES 3
VahidDM
Super User
Super User

Hi @munnaz 

 

You can use Dax Studio and easily export each table to Excel 

https://daxstudio.org/

 

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

Appreciate your Kudos!! 

 

LinkedIn|Twitter|Blog |YouTube 

Hi @VahidDM thanks!!

 

This works but doesn't explain as to why this is happening? It is a recent occurance as I used to be able to copy to excel without issues. 

Your solutions is great @VahidDM 

Hi, @munnaz 

If you've already solved the problem at hand, you can mark a helpful reply as a solution so that the rest of the community can quickly find an answer if they have the same need.
If you can provide some screenshots of the steps that do not include privacy, or describe the steps you have taken, it will help me answer your questions.
In my tests, if I export the data in the table visual, it is saved as a csv file by default, as shown in the following image:

vjianpengmsft_0-1718941993763.png

vjianpengmsft_1-1718942018050.png

 

vjianpengmsft_2-1718942059957.png

 

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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

 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors