Power BI Analyzer

Bronze Certified

Custom Activity

0 reviews

408

Power BI Analyzer

Bronze Certified

Custom Activity

0 reviews

408


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: 21 Jul 2020 | Updated: 18 Dec 2020

VENKAT RAMANAN K R
RPA Developer

License

Apache 2.0


Code Language

Visual Basic


Runtime

.NET Framework


Tags

CG2020
Formulas
Measures
microsoft
PowerBi
PowerBi_Analyzer
Tables

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


Similar Listings