topic Re: PBI Admin Datasource API error - DMTS_UserNotFoundInADGraphError in Developer

PBI Admin Datasource API error - DMTS_UserNotFoundInADGraphError

DanrleiAlves — Tue, 22 Jul 2025 07:28:49 GMT

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!

Re: PBI Admin Datasource API error - DMTS_UserNotFoundInADGraphError

v-hjannapu — Tue, 22 Jul 2025 12:01:41 GMT

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.

Re: PBI Admin Datasource API error - DMTS_UserNotFoundInADGraphError

v-hjannapu — Sat, 26 Jul 2025 12:07:30 GMT

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.

Re: PBI Admin Datasource API error - DMTS_UserNotFoundInADGraphError

Jai-Rathinavel — Sun, 27 Jul 2025 07:39:28 GMT

Hi @DanrleiAlves

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

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.

Re: PBI Admin Datasource API error - DMTS_UserNotFoundInADGraphError

v-hjannapu — Tue, 29 Jul 2025 11:37:09 GMT

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.

Re: PBI Admin Datasource API error - DMTS_UserNotFoundInADGraphError

v-hjannapu — Fri, 01 Aug 2025 11:31:23 GMT

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.