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 · Accepted solution]

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.

[Jai-Rathinavel · Accepted solution]

Hi @DanrleiAlves  

1. Check if the dataset is in deleted state - powerbi - Power BI REST Admin - Datasets GetDatasourcesAsAdmin return DMTS_UserNotFoundInADGraphErro...

2. If you have access to Fabric Workspace you can try Sempy python library (fabric.list_datasources()). Even if it doesn't work.

3. Open the semantic model on Tabular Editor and under Tables->Partitions->Expressions you can see the Power Query used to build that table.

[v-hjannapu · Accepted solution]

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.

[v-hjannapu]

Hi @DanrleiAlves,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.


Regards,
Harshitha.

[v-hjannapu]

Hi @DanrleiAlves,
I wanted to follow up and see if you have had a chance to review the information that was shared. If you have any additional questions or need further clarification, please don’t hesitate to reach out. I am here to assist with any concerns you might have.

Regards,
Harshitha.