Forum Discussion
Issues with .csv Export from Power BI to Excel – Incorrect Formatting in Excel
CSV generally has no meta data - no formatting, whatsoever. If you want the data in an Excel friendly format (for your locale) then you need to preformat it accordingly in Power BI.
Hi JohnZiad555 ,
Based on my testing, please try the following method:
1.Go to the Data tab in the Excel.
2.Click get data > From Text/CSV.
3.Select the file and choose import.
4.Select Load or Transform.
But, the Excel cell has digit limitation. The max is 11. If the data beyond 11 digit, the number do not display.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
CSV generally has no meta data - no formatting, whatsoever. If you want the data in an Excel friendly format (for your locale) then you need to preformat it accordingly in Power BI.
@Ibendlin is correct. May I add, that in addition, if the concern is display
as Scientific Notation, than the answer would be to change the
Formating of the Cell. This has always been true (as long as my memory serves),
and a small task when preparing an Excel report for distribution.
Explanation:
By default, Excel cells are in the 'General' format, which automatically
converts numbers longer than 11 digits into scientific notation.
The simplest way to remove these scientific notations and retrieve the
original numbers is to change the format of these cells (and apply
the Number format).
There are two ways you can quickly change the format
of the cells in Excel—using the Format Cells dialog box and by
using the formatting dropdown in the ribbon.