Extract Measures and its Description, Source Information, and Relationships from Power BI template.
Project description
✔ Power BI Automation Using Open AI API
Problem Statement:
- Power BI documentation is essential for maintaining the accuracy and integrity of data models, ensuring compliance with regulations, and improving collaboration and efficiency across teams.
- It is a time-consuming task that requires more human intervention and is highly error prone.
- Our model aims to automate this process using OpenAI's NLP capabilities.
Purpose:
- The purpose of our Power BI model documentation automation is to provide a Time-saving and Accurate solution for fetching pbix details. Below are the purpose that our model is fulfilling:
- Automating the Power BI model documenter using one of the most efficient GPT-3 architecture i.e.
text-davinci-002
. - Fetched the
Measures
,Source Information
, andModel Relationships
attributes from the Power BI report. - Wrote back the Measures and Modification Descriptions and displayed on hovering the respective properties in updated pbit files.
- Presented the output into three directories, namely
EXCEL
,JSON
andUpdated PBIT
.
- Automating the Power BI model documenter using one of the most efficient GPT-3 architecture i.e.
Input/Output Deliverables:
- Input:
- Single File
- Multiple Files
- A Folder
- Output:
- Excel Directory
- JSON Directory
- Updated PBIT Directory
Features:
- Implemented following features in our model:
-
Features in JSON Deliverables:
DataModelSchema Generation
: Generated the datamodelschema file for the respective pbit file and stored it in JSON format.
-
Features in EXCEL Deliverables:
Measure Sheet
:- Measure Name
- Measure Expression
- Measure Data Type
- Measure Description
Source Information Sheet
:- Table No
- Table Name
- Table Mode
- Table Type
- Table Source
- Original Table Name
- Table Query
- Modification
- Modification Description
Relationships Sheet
:- From Table
- From Column
- To Table
- To Column
- State
- Direction
- Cardinality
-
Features in UPDATED PBIT Deliverables:
Dynamic Hover Description
: Made the Measures and Modifications Description to hover on each respective properties.
-
Prerequisites:
- In order to use this script, one need to ensure to met the following requirements:
- A Power BI Desktop installation (version - 2.115.663.0 64-bit).
- A valid API secret key for OpenAI's NLP capabilities.
- Python 3.7 or later installed on your machine.
- Access to the Power BI models that you want to document.
✔ Package Description
PyPbitExtractor
- Created a python package for the given python script and published it on https://pypi.org/
Package Usage
- from PyPbitExtractor import Extractor
- This command will install all the uninstalled required libraries used in script.
- Extractor.api()
- This command will prompt user for Open API Secret Key.
- Extractor.main()
- This will prompt user for input of file selection and thereafter the repective file/folder.
Package Installation
pip install PyPbitExtractor
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
pypbitextractor-1.1.3.tar.gz
(9.8 kB
view hashes)
Built Distribution
Close
Hashes for pypbitextractor-1.1.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 33e5e8fbc3adfaceb94ab1f190e24a68e2ad8c57d67e21ecea0f806fbefc6093 |
|
MD5 | f882d47fe4776b3ba4f0515f1edb1da5 |
|
BLAKE2b-256 | b553b691e82d81ef4747e5016a92ed94804592bf15ed53bd92e06e971dc877b5 |