Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
@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
@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
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |