English
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:
- Measures
- Tables
- Tables and Columns
- Calculated Columns
- 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: 2020-07-21T08:26:59+00:00 | Updated: 2020-12-18T00:00:09+00:00
VENKAT RAMANAN K R
RPA Developer
License
Apache 2.0
Code Language
Visual Basic
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
Support
UiPath Community SupportSimilar Listings
