List of All Connections and Owners at Tenant Level

[sahilmehta9]

Hi,

I am looking to obtain a list of all connections and their respective owners at the tenant level within Microsoft Fabric.

As of now I can only see all the connections specific to me.

With this, can i also get a list of users associated to a specific connection? Meaning the owner name and the people with whom the connections is shared with

Thanks,

Sahil

[frithjof_v]

@sahilmehta9 did you find a solution or learn something regarding your original question? I am curious about the same

I am looking for this kind of functionality:

1. Is there an API to list all connections, which users each connection is shared with, and which items (semantic models, dataflows, pipelines, etc.) that are using each connection?

If not, what is the recommended way to keep track of who has access to a shared cloud connection and where it is being used?

2. Is there an API to assign connections to items? Let's say we have a connection which is used for 100 items. Now the source database has been migrated to another server address, and we need to update the source path of the connection. It's not possible to change the source path of an existing connection (?). So we would want to create a new connection and apply the new connection to the same 100 items, and remove the old connection. Is there an API for this?

Can any of the existing API's be used for this?

Thanks!

[lbendlin]

@frithjof_v please be more specific what you mean by "connection"  and "item".   Is your question geared towards semantic models / dataflows or towards gateways?

[frithjof_v]

By items, I'm referring to semantic models, dataflows, etc.

By connection, I'm referring to the connection which is used to connect the item to it's data sources.

https://learn.microsoft.com/en-us/power-bi/connect-data/service-create-share-cloud-data-sources

So I'm wondering which API's can be used for listing these connections, and listing which users have access to use these shared connections, and listing which items (semantic models, dataflows, etc.) are currently relying on each connection.

Thanks!

[lbendlin]

For anything but dataflows you run the DMV queries against partitions and expressions. For dataflows you export the .json 

[frithjof_v]

Afaik, this will only tell me which data source is being used for each item.

It won't tell me which connection is being used to authenticate to the data source, nor will it tell me which users have permission to use the shared connection. 

I'm looking for an API (or another unified interface) which enables me to list all the connections (similar to the Manage gateways and connections page in Power BI Service), and list all the users which have permission to use each connection, and also for each connection list the items which rely on that connection for authentication to one of it's data sources.

Ref. the comment from Jordan in the comments of this blog post:

https://blog.crossjoin.co.uk/2023/09/17/multiple-connections-to-the-same-data-source-in-the-power-bi...

Btw, I love that blog. Tons of amazing content there! I'm just wondering what tools we can use for managing these shared cloud connections.

[lbendlin]

nor will it tell me which users have permission to use the shared connection. 

Sounds like you are looking at gateway connections after all.  Bad news - Unless you use credentials pass through (only available for a few data source types)  the scope of the gateway connection user defines what any other user will see.  There is zero auditing for "which users have permission to use the shared connection".   There is also no API to list the connection users and their permission level (we have a ticket open with Microsoft  for that).

[mariussve1]

Hi,

If you think my answer provided some kind of a soulition, please consider accepting it as soulition and click the button. I also greatly appreciate if you give me a kudos 🙂

Br

Marius

[mariussve1]

Hi,

Do you use Fabric Data Pipeline and Fabric Warehouse or OneLake?

If so I can provide you a json config for Data Pipeline where I use API and put the result in a table.

Br

Marius

[lbendlin]

No, we use PowerShell. We like to keep control of our processes and data.

[mariussve1]

Hi again,

I see. Then you can use the invoke-restmethod cmdlet on some apis.

To Get all datasets in all workspaces you can use: Admin Get datasets.

https://learn.microsoft.com/en-us/rest/api/power-bi/admin/datasets-get-datasets-as-admin

This will give you the owner, datasetid and groupid (workspace).

Then you can traverse over this with a for each in powershell on this api:

https://learn.microsoft.com/en-us/rest/api/power-bi/admin/datasets-get-dataset-users-as-admin

This will give you all the users on datasets.

Marius

[lbendlin]

You can still post the JSON here for anyone else who might be interested.

[lbendlin]

Use the Scanner API.

[sahilmehta9]

can you provide a detailed link w.r.t Scanner API for this specific purpose

[lbendlin]

Admin - REST API (Power BI Power BI REST APIs) | Microsoft Learn

or

Gateways - REST API (Power BI Power BI REST APIs) | Microsoft Learn