cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ramalingappabt
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.

3 REPLIES 3
Icey
Community Support
Community Support

Hi @ramalingappabt ,

 

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

Reference:

Announcing: Copy a Visual as an Image;

Copy and paste a report visualization.

 

 

Best regards

Icey

 

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

AllisonKennedy
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. 

 

https://support.microsoft.com/en-us/office/create-an-advanced-query-power-query-9f08ceac-c949-4408-b....

 

 

https://support.microsoft.com/en-us/office/power-query-advanced-editor-cbf29700-58bd-4e43-a6a3-a0330...

 


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.
www.excelwithallison.com

mahoneypat
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.

 

Regards,

Pat





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

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.