Forum Discussion
Admin API is very slow
We have started to use the Power BI Service for internal and external reporting. One of the gaps is the ability to see and report on refreshes and subscriptions (across the tenant). The monitoring app is great for current/recent refreshes, but we need a report for this.
So, I connected to the admin API via PBI Desktop. We don't have many workspaces or reports. We probably have under 300 reports in total. When I connect to the objects via the API, it is incredibly slow. All I am doing is pulling in the objects (unfiltered), but it never completes or takes over an hour. The objects are workspaces, semantic models, reports, and refreshes.
I even downloaded a connector to see if that works better. It makes the connection much easier, but it has the same trouble pulling from the API.
Just curious if others experience the same thing and what Microsoft can do about this? In contract, If I connect to Salesforce, ServiceNow, other common connectors, I have no problem pulling in thousands of records in only a few minutes.