Forum Discussion

ReyCarter's avatar
ReyCarter
Icon for Helper I rankHelper I
5 years ago
Solved

Export data from Power BI Desktop visuals in Excel format (XLSX)

Good time of day! Friends, tell me, when will it be available in the Desktop version of uploading to an Excel file? Now it is very inconveniently done. You have to replace the commas in the text va...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    ReyCarter 

    I afraid this kind of feature is unlikely to be included. Power bi has better visualization system while excel is also very limited to sharing reports which power bi overcomes it. They are just 2 separate products with some similarities. 

     

    Regards
    Paul

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I tried this and it worked.

Step 1: Go the column/measure where you cant see comma and decimal after export to excel/csv.
Step 2: Remove the comma and decimal from that column/measure in data view of power bi. Change the decimal to none or 0 or auto whatever the first option is. and then remove the comma by clicking on it.
Step 3 :Now you have to readd. Click again on that column and first Click on decimal . Add 2 decimal(Just an example).
Step 4 : Then comma would be auto selected otherwise not shown then select the comma too.

I know it sounds weird to remove and readd, but that worked for me several times.