Forum Discussion

CherryKom's avatar
CherryKom
Frequent Visitor
3 years ago
Solved

How to export filtered and conditional formatted table data into excel in powerbi desktop

Hi,

 

I'm using a table visual with 15 columns. Conditional formatting is applied for a few columns and visual-level filters were also included for the data in the table. Now I would like to export the conditional formatted (along with colors) and filtered data into an excel file and send it as an email attachment daily. Can someone kindly suggest possible ways to achieve this?

 

Thanks in advance.

Need Help
  • vicow's avatar
    vicow
    3 years ago

    Hi CherryKom,

    I have the same problem.

    I partially solved it with this method :
    - Create a flow with powerautomate that extract your powerbi data and put it in an excel table, previously created in a sharepoint for example.

    - Create a button in powerbi to lunch this flow.

    You can find more info on the web about this.

    Cheers,

    Victor

2 Replies

  • vicow's avatar
    vicow
    New Member
    3 years ago

    Hi CherryKom,

    I have the same problem.

    I partially solved it with this method :
    - Create a flow with powerautomate that extract your powerbi data and put it in an excel table, previously created in a sharepoint for example.

    - Create a button in powerbi to lunch this flow.

    You can find more info on the web about this.

    Cheers,

    Victor

    • CherryKom's avatar
      CherryKom
      Frequent Visitor
      3 years ago

      Thanks Victor, tried the same and solved the problem for now.