How to get connected to Power BI using UiPath Studio

[Krithi1]

How to get connected to Power BI using UiPath Studio

I need to fetch the data from Power BI tool often. How can I get connected to Power BI query and get the data using Studio?

[irahmat (Indra Rahmat)]

please prefer to this link https://forum.uipath.com/t/how-to-create-charts-in-powerbi-desktop-using-uipath-studio

[fernando_zuluaga]

Hi @Krithi1

Here it is the tutorial

TUTORIAL: Connect Power Query (Power BI) to Orchestrator API

TUTORIAL: Connect Power Query (Power BI) to Orchestrator API This tutorial will demonstrate how to connect Power Query to the Orchestrator API. This will allow you to use data analytics tools such as Power BI to create reports and dashboards using data from Orchestrator. This tutorial will show how to connect to the Orchestrator API data source. Note that if you can connect directly to the SQL Server database, then you don’t need to use the API. The method detailed here is useful in situations …

Regards

[Krithi1]

I don’t think that matches to what I am looking for. Or are you trying to say there is no way to get connected to Power Bi using Studio?

I am trying to get connected to Power BI(Desktop or Web) and refresh the relevant data there and download the excel report.

[ABHIMANYU_THITE1 (ABHIMANYU THITE)]

Hi @Krithi1,

To connect to Power BI using UiPath Studio, you can use the “Power BI Activities” package provided by UiPath. This package provides a set of activities that allow you to interact with Power BI, including refreshing data and downloading reports.

Here are the steps to connect to Power BI and download a report:

1. Install the “Power BI Activities” package in UiPath Studio.

• Open UiPath Studio and click on “Manage Packages” in the “Project” tab.
• Search for “Power BI Activities” in the “Official” tab and click “Install”.

2. Open the Power BI report you want to download and copy its URL.
3. Create a new UiPath project and add the “Open Browser” activity to the workflow.

• Set the URL property to the Power BI report URL.

4. Add the “Power BI Application Scope” activity to the workflow and set its properties:

• Authentication Type: Windows
• Workspace: (optional, if you have multiple workspaces)
• Report: (optional, if you have multiple reports in the workspace)
• Report URL: (paste the Power BI report URL here)

5. Add the “Refresh Report” activity inside the “Power BI Application Scope” activity.
6. Add the “Export Report” activity inside the “Power BI Application Scope” activity.

• Set the Output Format property to “Excel”.
• Set the Output File Path property to the desired location to save the downloaded report.

Once you have set up these activities, you can run the UiPath workflow to refresh the Power BI report and download the updated data in Excel format.

[Anil_G]

@Krithi1

Power bi pulls the data from some db and it would be ideal to pull the data feom there…but if you are still looking for power bi app only then try with ui automation of manually clicking on the reports and clicking export from menu or by right clicking on the reports…

Cheers