معرفی شرکت ها
PyDaxExtract-0.2.1
تبلیغات ما
مشتریان به طور فزاینده ای آنلاین هستند. تبلیغات می تواند به آنها کمک کند تا کسب و کار شما را پیدا کنند.
مشاهده بیشتر
تبلیغات ما
مشتریان به طور فزاینده ای آنلاین هستند. تبلیغات می تواند به آنها کمک کند تا کسب و کار شما را پیدا کنند.
مشاهده بیشتر
تبلیغات ما
مشتریان به طور فزاینده ای آنلاین هستند. تبلیغات می تواند به آنها کمک کند تا کسب و کار شما را پیدا کنند.
مشاهده بیشتر
تبلیغات ما
مشتریان به طور فزاینده ای آنلاین هستند. تبلیغات می تواند به آنها کمک کند تا کسب و کار شما را پیدا کنند.
مشاهده بیشتر
تبلیغات ما
مشتریان به طور فزاینده ای آنلاین هستند. تبلیغات می تواند به آنها کمک کند تا کسب و کار شما را پیدا کنند.
مشاهده بیشترتوضیحات
Extract Table Relationships, m expressions, and DAX expressions from Power BI template.
| ویژگی | مقدار |
|---|---|
| سیستم عامل | OS Independent |
| نام فایل | PyDaxExtract-0.2.1 |
| نام | PyDaxExtract |
| نسخه کتابخانه | 0.2.1 |
| نگهدارنده | [] |
| ایمیل نگهدارنده | [] |
| نویسنده | Doug Shawhan |
| ایمیل نویسنده | doug.shawhan@gmail.com |
| آدرس صفحه اصلی | https://gitlab.com/doug.shawhan/pydaxextract |
| آدرس اینترنتی | https://pypi.org/project/PyDaxExtract/ |
| مجوز | Copyright 2021 Doug Shawhan Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: 1. Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer. 2. Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution. 3. Neither the name of the copyright holder nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission. THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. |
# PyDaxExtract
Extract table relationships and `m` and `DAX` expressions from a `Power BI` template file.
`Power BI` files in the `pbix` and `pbit` formats are basically zip archives containing other compressed data.
The `DataModel` file in a `pbix` file contains all the `DAX` expressions created when processing data. All data is saved in the `Xpress9` format, which is a proprietary compresson method optimized to dump memory to disk and vice-versa, with encryption and all kinds of other wonderful features which will break you heart if you try to get a peek inside.
Fortunately, if one saves a `Power BI` workbook as a template, the table relationships, `m` expressions and `DAX` expressions are now saved in the `DataModelSchema` object, which is unencrypted and requires only a bit of fiddling to remove.
This module, and command-line script are intended to help with that fiddling, and to aid users in serializing work done in an otherwise fairly opaque binary format. Here's hoping it's useful to you.
At this point, there appears to be no way to automate exporting `pbix` files as `pbit`, so you'll have to do that the usual way.
This script will work as long as it does, given the rate of churn (I mean development) in `Power BI`. Good luck!
# Usage
## Module
```python
from pathlib import Path
from dax_extract import read_data_model_schema
pbit_path = Path("/path/to/my_awesome.pbit")
data = read_data_model_schema(pbit_path)
```
## Command Line
```
usage: daxextract.py [-h] [--dump-json] [--dump-expressions] [--write-dax-csv]
[--write-powerquery-csv] [--write-relationships-csv]
pbit_path
Extract PowerQuery (m) / DAX expressions from Power BI template file.
positional arguments:
pbit_path Path to .pbit file.
optional arguments:
-h, --help show this help message and exit
--dump-json Write full dump of DataModelSchema to stdout in json
format.
--dump-expressions Write DAX and PowerQuery (m) expressions to stdout in
json format.
--write-dax-csv write csv file containing DAX measures and metadata in
csv format.
--write-powerquery-csv
write csv file containing PowerQuery expressions and
metadata in csv format.
--write-relationships-csv
write csv file containing table relationships in csv
format.
```
# Installation
```bash
pip install pydaxextract
```
نحوه نصب
نصب پکیج whl PyDaxExtract-0.2.1:
pip install PyDaxExtract-0.2.1.whl
نصب پکیج tar.gz PyDaxExtract-0.2.1:
pip install PyDaxExtract-0.2.1.tar.gz