Data Source strings from the API

[rachellek]

Is it possible to use the API to get a list of data source connection strings used for Power BI datasets and dataflows? Not just the Connection String, but the underlying assets that the connection is using.

I ask because we have a wild garden of bespoke datasets and dataflows in our capacity connecting to an oracle warehouse, and are trying to get a consolidated view of the tables that are in use. Power BI developers have connected by either connecting directly to the tables, or by connecting using a sql query.

We are able to extract the connection string through the API, so can identify which datasets and dataflows are using the oracle connection, but want to go the next step to find out WHAT is being queried.

Is this possible? Thank you.

[v-shex-msft · Accepted solution]

HI @rachellek,

I think you can try to use multiple api to achieve your requirment. You can use the 'Datasets - Get Datasources In Group' API to get the detailed data source configuration and mapping information.

Datasets - Get Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs

After these steps, you can extract these IDs to interact with other APIs to get detailed information. (e.g. refresh log, activities)

Datasets - Get Refresh History In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Admin - Get Activity Events - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Regards,

Xiaoxin Sheng