Power BI Analyzer

Bronze Certified

Custom Activity

0 reviews

282

Power BI Analyzer

Bronze Certified

Custom Activity

0 reviews

282


Summary

Analysing the Power BI projects and extracting all the information such as Measures, Tables, Datasources, etc. as descending those details is not an easy task

Overview

Users require PowerBI application in an installed manner.

1. Download this .nupkg and save it in your desired location.
2. Open a blank process and then use “Manage Activities”, install UiPath.Database.Activities and Power_Bi_Analyzer activity under the CG2020 RPA Elites package.
3. Drag and drop the Power_Bi_Analyzer activity in a sequence and fill the following details.
4. In the Property pane of Power_Bi_Analyzer activity input:
  • Filepath: Location of the Power BI file with its name and extension (.pbix) should be provided.
  • Parameter: Users need to provide anyone of the following parameter as string:
  1. Measures
  2. Tables
  3. Tables and Columns
  4. Calculated Columns
  5. Datasources

N.B: Pass the name with the same spelling as we have provided above.
ResultTable: The output will be saved in a DataTable format. Assign a variable for this parameter.

Benefits


Published: Jul 21, 2020 | Updated: Dec 18, 2020

VENKAT RAMANAN K R
RPA Developer

Chennai, Tamil Nadu, India


License

Apache 2.0


Code Language

Visual Basic


Tags


Compatibility

UiPath Studio 2020.4.1


Dependencies

1. Users should install SQL_AS_OLEDB.msi from https://www.microsoft.com/en-us/download/details.aspx?id=49999 2. Power BI application should be installed on the same machine