Tabular Object Model for AnalysisServices and PowerBI
Automation repo for TOM engine in AAS and PowerBI
The portion of this script that allow accessing the TOM engine is thanks to the hard work of yehoshuadimarsky his ssas_api.py allowed me to create a read, write,refresh application for working on AAS/PowerBI servers.
Prerequisites:
1- This script requires 2 dll's to be installed prior to execution and can be downloaded from the microsoft client libraries for .net. You will need the ADOMD and AMO packages installed in your machine.
2- All 4 scripts must be placed in the same python project folder or you will need to use folder references in your import method.
Notes:
1- The main main method for getting data out of TOM is the microsoft .net SDK. This code can be augmented by adding more classes as seen on the documentation for Microsoft.AnalysisServices.Tabular
2- The date "12/31/1699 12:00:00 AM" you see in the PyTOM.py script is how TOM stores null dates for my purpose i wanted to find partitions that have never been refreshed i am targetting those dates to send over to my refresh script.
3-The AAS_REFRESH script requires the ASA_BEARER_TOKEN to be set up and is set up to use object inputs from PyTOM but can be run without PyTOM by manually building the pyload object
4- PyTOM uses ssas_api and can be used as stand alone to query and execute operations on a specific aas server. I also use it to create a repo of dax measures for CDC processes
PD:
1- I will be cleaning up the code to use classes eventually to make it cleaner but for now everything has been tested and is working