Automation with PowerBI

Hi Team,

Can anyone provide detailed way of automating PowerBI with UiPath using API, as I am new to working with API’s. Requirement is to get the data or extract the reports from PowerBI to UiPath.

Thanks!

@Rama_Thota

Http request activity willhelp in UiPath…

Alternately can use intwgration services as well

The api details are here Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn

Cheers

Hi Rama,

I agree with Anil’s suggestion, he always shares interesting insights. :slight_smile:

My two cents here would be more from an architectural point of view. Exacltly, what data are you extracting, and… what will UiPath do with it? Sometimes we (or our stakeholders) want to automate everything through UiPath while in some scenarios it could overkill the solution, in other words it might not be worth the effort.

Power BI is a visualization tool, if you were to extract data, for whatever purposes I think it would be easier to extract it directly from the source, my recommendation is to get together with a requirements engineer (if you have one on your team), the process stakeholder and whoever administer such Power BI dashboard and find a balance between ease of extraction and reliability.

I know the concepts are abstract but certainly they give value to the solutions we provide.

Happy automation :robot:

I wholeheartedly agree with your thoughts :grinning:

The famous saying goes like this: “If the only tool you have is a hammer, you tend to see every problem as a nail.

UiPath is a brilliant automation platform, but that doesn’t mean that you should use it for everything everywhere.
Identify the data source for Power BI and get the report data directly from there. However, if the Power BI developer has massaged the data a lot using the Power Query editor, then there is a good case to access data from the Power BI report. In most PBI you can schedule exporting visuals as tabular data, which UiPath would then be able to utilise.
For the scheduled data export (to Excel), you can use the free automation product that comes as part of the Power platform :wink:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.