Forum Discussion
PBI Admin Datasource API error - DMTS_UserNotFoundInADGraphError
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:
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!
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.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.
5 Replies
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.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.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.
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.