Data Source strings from the API

rachellek — Thu, 07 Jul 2022 08:28:57 GMT

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.

Re: Data Source strings from the API

Anonymous — Mon, 11 Jul 2022 06:02:33 GMT

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

topic Re: Data Source strings from the API in Developer

Data Source strings from the API

Re: Data Source strings from the API