Exported data is now showing as it is

[Avian65]

I have almost 2000 records shwing in Matrix in with multiple columns, whenever we select Export Data, it is exporting in CSV, but when I open report CSV in excel, it is not showing same format as displaying in Matrix.

Is there any other option to export data to CSV or Excel as it is, as displaying in Matrix?

Regards

Avian

[Avian65]

Amit,

Canyou please tell me what is the location of this option? How can we give this option to end user? We are not allowing user to use PowerBI Desktop. Matrix visual we are filling with SharePoint Data and user can see the report on web.

Regards

Avian

[Anonymous · Accepted solution]

Hi @Avian65 ,

//Canyou please tell me what is the location of this option?

//How can we give this option to end user?

You need the report owner to allow users to export and the Power BI admin to allow users to export data in the tenant settings(This can all be done in the service). Other times, there may be particular reasons an export does not work. It could be related to permissions, data contents, data type, visual type, how the designer named the fields, and more. 

Please refer: Export data from a Power BI visualization

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[amitchandak]

@Avian65 , In power bi service export you have an option for Summarized data