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

[CherryKom]

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.

[vicow · Accepted solution]

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]

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