Forum Discussion

manojk_pbi's avatar
manojk_pbi
Helper V
1 year ago
Solved

Power BI Export to Excel

Hello    I have table chart with colod coding, delta change indicators etc, how can we export this table as in to excel. I don't see any options to export with all color coding. One i tried is expo...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    1 year ago

    Hi manojk_pbi ,
    Thanks for reaching out to the Microsoft fabric community forum.

    You can use Analyze in Excel, which lets you connect Excel pivot tables directly to your Power BI dataset. While this approach won’t automatically bring over Power BI’s conditional formatting, you can easily recreate the same rules using Excel’s built-in conditional formatting features.

     


    Another option is to use Power BI paginated reports and creating visualizations with it,
    and they can be exported to Excel with all formatting preserved.

     

     

     

    I hope this information helps. Please do let us know if you have any further queries.
    Thank you


v-nmadadi-msft's avatar
v-nmadadi-msft
Community Support
1 year ago

Hi manojk_pbi ,
Thanks for reaching out to the Microsoft fabric community forum.

You can use Analyze in Excel, which lets you connect Excel pivot tables directly to your Power BI dataset. While this approach won’t automatically bring over Power BI’s conditional formatting, you can easily recreate the same rules using Excel’s built-in conditional formatting features.

 


Another option is to use Power BI paginated reports and creating visualizations with it,
and they can be exported to Excel with all formatting preserved.

 

 

 

I hope this information helps. Please do let us know if you have any further queries.
Thank you


  • manojk_pbi's avatar
    manojk_pbi
    Helper V
    1 year ago

    Thanks for your suggestion. Let me check the option

  • SIVAChitti's avatar
    SIVAChitti
    New Member
    9 months ago

    Hi, I have a question here,, suppose we have 20 Visuals in Pbi report, can we export this 20 visuals to excel with external tools like analyse in excel?