Showing results for 
Search instead for 
Did you mean: 
New Member

Saving pbix file to excel file

I have developed power BI report using Power BI report using Power BI desktop free version. I have done conditional formatting in the report where in I need to apply colors for some fields in the report. I have published the reports in the power BI service.


Now after publishing in the power BI service, I need to export this report into Excel format. I am not getting option to export this report as excel, but getting option to export it as CSV file. I am not able to see coloured field in CSV file.


Could you please help me how to resolve this issue? Do I need to build this report as paginated reports? Then only I would get option to this file as excel and I can see the colors in excel file? Please suggest.

Community Support
Community Support

Hi @ramalingappabt ,


How about copying and then pasting report visualizations from Power BI to Excel?


Announcing: Copy a Visual as an Image;

Copy and paste a report visualization.



Best regards



If this post helps, then consider Accepting it as the solution to help other members find it faster.

Super User
Super User

@ramalingappabt  You don't need to use paginated reports - you could use Excel Power Query. You will need to click Transform Data in Power BI Desktop, then Advanced Editor. Copy the entire code from there. Then open Excel New workbook. Click Data Tab > Click New Blank Query. Paste the code into advanced editor in excel.


You will need to recreate the visuals/tables and conditional formatting within Excel directly.


Please @mention me in your reply if you want a response.

Check out my Tokyo 2020 report with live stats - KUDOS much appreciated

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.

Super User
Super User

You could build it as a paginated report, but I'm not sure that Excel file would come with conditional formatting.  Could you export your current report page from the Service in PowerPoint or PDF format to keep the colors?


You could also copy/paste your query to Excel powerquery and use powerpivot and Excel features to make your report directly.




Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

Helpful resources

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors