Power BI Analyzer

Custom Activity

Custom Activity

Updated: October 7th, 2020

Published: June 17th, 2020

Downloads: 14

Industry: finance-and-insurance

Language compatibility: Visual Basic

Community Support

Power BI Analyzer

Custom Activity

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

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.

Details

Benefits

1. Used to analyse the entire Power BI file by fetching its Measures, Tables, Columns, Datasources, etc.
2. It will be a time efficient process to analyse the Power BI data

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

Licensing

By clicking download you agree to the following license.