Forum Discussion

JohnZiad555's avatar
JohnZiad555
Regular Visitor
2 years ago
Solved

Issues with .csv Export from Power BI to Excel – Incorrect Formatting in Excel

Hello Power BI Community,   I am encountering an issue with exporting data from Power BI to a .csv file and then opening it in Excel. Here’s a brief description of the problem:   Context: I have...
Data Protection
Show and Tell
Tips and Tricks
Tutorial Requests
  • lbendlin's avatar
    lbendlin
    2 years ago

    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.

  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.