Using r to pull data from app.powerbi.com

[Anonymous]

I've been searching and searching trying to find out whether or not something can be done.

There is a Power BI report within my company that I have access to. For reasons to complicated to explain, I need to reproduce some of the visualizations in my own Power BI dashboard.

Currently, what I have to do is click on a graph and export the underlying data, which comes as a csv file. I have to do this manually for 3 different plots. I know Power BI can do some web scraping, but I get access issues, if I try to do this using Power BI. I've learned from our IT, that in order for me to do this, I'd have to be named as a co-owner of the site I'm scraping. I'm not sure that can happen.

Is there a way I could use R from my end to export the underlying data for me?

To be clear--I can manually export the underlying data I need just accessing the site through my browser. I'd like to be able to have either R or Power BI do this for me.

Thank you in advance for any help or suggestions!

Bruce

[v-shex-msft · Accepted solution]

Hi @Anonymous,

Nope, power bi service not support to use r script.(editor functions and coding formula has been disabled on power bi service side)

You can only consider to use existed features to export data.

Export data from visualizations

If you mean use r script to get data from power bi, you can refer to below blog to get data from power bi rest api:

How to Access Any RESTful API Using the R Language

Regards,

Xiaoxin Sheng