R and Power BI

[Anonymous]

Hi,

I currently have 2 Power BI Matrix visuals in one page. I need to export the visual to Excel (properly formatted)

I've tried using export Data, but this doesnt retail table formatting. Also, I need both my visuals to be exported simultaneously.

I've built an R script in R studio to export the Power BI data to Excel. Is there a way I can use a button in Power BI to run the R script to export into xlsx? 

Regards,

aRa_4

[V-pazhen-msft · Accepted solution]

@Anonymous 

I doubt you can export only Data in the matrix visuals using R/Python script. As far as I know, you can only export dataset or data field. Take a look at:

Quick Tips – Export data from Power BI using R | Mitchellsql (mitchellpearson.com)

Use R to export data from Power BI – The BIccountant

Paul Zheng _ Community Support Team

[amitchandak]

@Anonymous , Power automate has enabled this kind of flows. But I am not sure of any R connector as of now.

Refer automate flow to export to excel with button, see you can use that - https://youtu.be/BnTipbooeP0

[Anonymous]

@amitchandak I'm currently not with Power BI Premium.