External Tools¶
This section provides some of the external tools that can be used with Analysis Models - Power BI functionalities.
Along with Power BI Desktop, there are free tools that integrate with Power BI Desktop's data modeling and reporting features.
| Tool | Usage | More details |
|---|---|---|
| Tabular Editor | Easily build, maintain, and manage tabular models | https://docs.tabulareditor.com/?tabs=TE3 |
| ALM Toolkit | To manage/compare Power BI Datasets | http://alm-toolkit.com/HowToUse |
| DAX Studio | DAX authoring, diagnosis, performance tuning, and analysis | https://daxstudio.org/docs/intro/ |
| Git | Power BI file version control | https://learn.microsoft.com/en-us/power-bi/developer/projects/projects-git |
Read more about Power BI Desktop External Tools.
Create or Customize a Model via Power BI Desktop¶
IFS Core Models or any other model can be customized via Power BI Desktop and uploaded back via the Upload Models page within IFS Cloud Web. Customizations can be simple changes (i.e. creating new measure(s)) from existing data sources, and changes done by adding new data sources to the model.
Loaded Parquet Data Sources in the ADLS Gen 2 container can be accessed from Power BI Desktop with the usage of a SAS Token.
How to connect to the ADLS Gen 2 container:
The obtained SAS Token can be used to consume these Parquet Data Sources, hosted on the ADLS Gen 2
Read more about connecting to Azure Data Lake Gen 2 Storage.
Note
When connecting to a Parquet Data Source within Power BI Desktop make sure to use the CDM Folder View as the Data View selection.
Once the Power BI customizations are completed, the related version needs to be saved locally for the Upload/Import processes.