Extra columns in export created by "-"

[munnaz]

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.

[VahidDM · Accepted solution]

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 

[munnaz]

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. 

[v-jianpeng-msft]

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:

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.