The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
Like with the schedule of the dataset, that can be queried from the API using
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-schedule
I hope to find a way to query the same for datamarts since they have a schedule
In the documentation
I found out that you can actualy get the "batches" of failed and succesful refreshes using this api
'https://api.powerbi.com/v1.0/myorg/datamarts/{datamartid}/batches'
thats undocumented in the learn documentation but it works.
But since it is only what has happened and not what is planned I like to know:
-if there is a way to list the datamart id of all datamarts in a group / workspace
-if there is a way to list the refresh schedule for each of the datamarts.
I know datamarts are still in preview but managing schedules is essential to me.
Thanks for suggestions on this
- not an official API endpoint. Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn
- you can harvest the refreshes via the Audit log Administration of datamarts (preview) - Power BI | Microsoft Learn
- datamarts are "in preview" and (in my opinion) will never make it into GA because they are being "replaced" by the Fabric features.
What gave me some kind of hope is that I found one "undocumented" api. That brought me to the feeling there might be others. for instance the schedule must be there somwhere. And the Platform needs the API of the schedule to work how would it else get that data to the web. So that gave me the feeling lets go for it and ask it to the Community maybe someone has it figured out. Anyone else?