Forum Discussion

rachellek's avatar
rachellek
Frequent Visitor
4 years ago
Solved

Data Source strings from the API

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 i...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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