PBI Admin Datasource API error - DMTS_UserNotFoundInADGraphError

[DanrleiAlves]

Hi everyone,

I'm running into an issue when trying to use the Power BI Admin API to retrieve datasource information for a specific dataset using its datasetId. Here's what I'm trying to do:

• Use the Admin API endpoint Get Datasources as admin (Admin - Datasets GetDatasourcesAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Learn) to get information about the datasource(s) used in a dataset.

• The dataset is connected to an Azure Synapse view, but I don’t know which database or table specifically.

• I was hoping this API would return the server, database, and object (table/view) name.

However, when I call the API, I get the following error: 

DMTS_UserNotFoundInADGraphError (image below)

Has anyone seen this error before?

Any suggestions on how to get around this error or alternative ways to retrieve datasource details (especially the Synapse database and view/table name) would be greatly appreciated.

Thanks in advance!

[v-hjannapu]

Hi @DanrleiAlves  ,

Thank you  for reaching out to the Microsoft fabric community forum.

Make sure you have these permissions

• The user must be a Fabric administrator or authenticate using a service principal.

Also try to follow this article Datasets - Get Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

and try to get the data source by following the provided HTTP code .

Make sure you have these permissions

Dataset.ReadWrite.All or Dataset.Read.All

Hope this helps if you have any queries we are  happy to assist you further.
Regards,
Harshitha.

[v-hjannapu]

Hi @DanrleiAlves.,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Regards,
Harshitha.