Before we could use the execute queries API to get partitions info from our tables using incremental refresh.
For example we could use INFO.PARTITIONS or SELECT DISTINCT [MEASURE_GROUP_NAME], [PARTITION_NAME] FROM $SYSTEM.DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS.
Those 2 functions does not work anymore when using the execute queries API.
We need another way to get partitions info using the Power BI API
2 Comments
- Status added:New
- Element115
Memorable Member
SGilbert3 couldn't you use a Fabric Notebook and the REST API to connect to your SSAS instance with the SSAS URL, something like this: powerbi://api.powerbi.com/v1.0/myorg/. With SSMS I can see all my partitions in the Power BI Service. I imagine Microsoft makes it possible to use Python in a Notebook to call the SSAS instance REST API and get the metadata back. And if they don't, they should.
