Connect to Power BI Report Server and download information

[Dylan1]

I have some reports in Power BI Report Server, and I have to download that information automatically. How can I connect Blue Prism with those tables?

Manually, I have to put the mouse cursor on the table, then press on 3 dots, click on Export data and wait. I hope there's a better way to do that automatically

Thanks!

[KaranSareen]

Hey Juan

Do you know if there is any API which can be called to download those files? If yes, then you can consume those within Blue Prism to call their functionality.

Moreover, I was searching the Blue Prism Digital Exchange for available connectors/ Skills which can be used for integrating BP with Power BI and found few of them. I would suggest you to look for them at DE and see if they suit your requirement.

------------------------------
Karan Sareen
Solution Support Engineer
Blueprism
Australia/Sydney
------------------------------

[TahaSonmez]

Hi Juan,

As I know there is no API for exporting the visual as Excel or PDF. We use SQL queries to get desired data from the database. You can find The correct SQL query for a visual in Power BI Community forums.

------------------------------
Taha Sonmez
ROM Architect
SabanciDx
------------------------------