Forum Discussion
Partial result returned from Power BI REST API Datasets - Get Dataset To Dataflows Links In Group
v-hashadapu Jai-Rathinavel FYI, the issue has gone by itself without changing anything and https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/upstreamDataflows is returning full list of datasets in all workspaces now.
Thanks both for your help.
Jai-Rathinavel v-hashadapu Thanks for your reply. We have a total of 120 datasets in 40 workspaces.
Try It!
All 120 datasets in 40 workspaces can be returned in different workspace/dataset related APIs I called.
Service Principal
The problem is only relaed to this API happened since last Thursday
https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/upstreamDataflows
It returns only 2 datasets from 2 workspaces. Before that, it can returns all 120 datasets in all 40 workspaces.
For other dataset related APIs like the following, they can return all 120 datasets in all 40 workspaces.
https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/datasources
https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes
FYI, I have been using service principal to call various APIs to auto grab info to build a power bi report to show the lineage view for all reports, datasets and dataflows, and it has been working for over a year, but the info about dataset to dataflow link suddenly broken as https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/upstreamDataflows only returned partial result since last Thursday. But the info returned by other APIs on workspaces, reports, datasets, dataflows still match with our full lists.
Sorry for I'm relatively new to these APIs and doesn't know much technical about them...😅
Super Userkuraki
1. Since the API is not working suddenly I would advice you to open a support ticket with the help of the platform admin, I have came across few sceanrios were the API which was working returning partial results
2. Can you check if the service principal has been added to all the workspaces ?
Jai-Rathinavel Thank for very much for your prompt reply.
1. Thanks. Will raise a support ticket.
2. Yes, service principal is added to all workspaces.