Get Dataflow Data Sources generates error 500

[Anonymous]

Hi Microsoft,

When running the following command:

GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/dataflows/{dataflowId}/datasources

It works for most DataFlows, but sometimes get the following error:

{
"error": {
"code": "",
"message": "An error has occurred."}
}
Please resolve.

Cheers, Steve

[aalaja]

Ran into a similar problem. It appeared the issue was caused by the dataflow owners no longer being present in the Active Directory. Taking ownership of the dataflows causing the errors fixed the issue.

[Anonymous]

Hi  @Anonymous  ,

Can you provide more detailed error information?

Regarding the problem of 500 when using rest api, checking the documentation shows that this is a server error, not a client error. I guess if there is a problem with your dataflow itself. When using rest api, also pay attention to the value {groupId}, { dataflowId} If you need to change, fill in the ID of the dataflow of which workspace you visit.

This is the website about rest api:

https://docs.microsoft.com/en-us/rest/api/power-bi/dataflows/getdataflowdatasources

This is about the error 500 of the Rest api:

https://stackoverflow.com/questions/27826491/rest-api-error-code-500-handling

https://restfulapi.net/http-status-codes/#:~:text=500%20is%20the%20generic%20REST%20API%20error%20response.,response%20and%20hope%20to%20get%20a%20different%20response.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.