Skip to main content

Power BI

Needs Votes

Power BI REST API connector for Power BI Desktop

Vote (28) Share
Jordan Kline's profile image

Jordan Kline on 17 May 2019 22:21:59

Create a connector to Power BI REST API so tenant/workspace admins have visibility into gateways, data sources, data source users, apps, workspaces, etc. Right now we can't use Power BI Desktop to query that information and build governance/oversight reporting. It's a huge missing piece for enterprise deployments.

Comments (4)
Jordan Kline's profile image Profile Picture

Gary Rogers on 29 Aug 2023 14:44:39

RE: Power BI REST API connector for Power BI Desktop

There is a BETA connector available as a custom connector, but this does not work in the service. The Admin API is brilliant, but needs to be integrated with Desktop and the service so that us normal people can use it.

Jordan Kline's profile image Profile Picture

Chris Burgess | ACTGOV on 09 Feb 2022 23:09:56

RE: Power BI REST API connector for Power BI Desktop

In Similar vein...Microsoft Idea (powerbi.com)

Jordan Kline's profile image Profile Picture

Gibby Gibby on 09 Feb 2022 20:12:48

RE: Power BI REST API connector for Power BI Desktop

Wow, thanks for the link, will check it out!

Jordan Kline's profile image Profile Picture

Other Gibby on 09 Feb 2022 20:11:47

RE: Power BI REST API connector for Power BI Desktop

Thanks @klinejordan for your work with @migueesc123 on migueesc123/PowerBIRESTAPI: A Microsoft Power BI Data Connector or Power Query Connector for the Power BI REST API (github.com)PLEASE Microsoft, could you take this excellent work and implement a first-party AAD Auth-enabled extension, that doesn't require constant hacking to make it work? An issue that we face over and over again is expiring access tokens. When refreshing via PBI Desktop, the token is refreshed without any issues. When refreshing in Power BI Service, the token expires and is not refreshed.