GetDatasetsAsAdmin response missing isOnPremGatewayRequired

[mkjit256]

I would like to get the datasets that requires OnPremGateway, and according to microsoft documentation, this should be caputred by GetDatasetsAsAdmin rest api (link to documentation). The URL i am calling is: GET https://api.powerbi.com/v1.0/myorg/admin/datasets

and according to the documentation the response should be: 

{
  "value": [
    {
      "id": "cfafbeb1-8037-4d0c-896e-a46fb27ff229",
      "name": "SalesMarketing",
      "addRowsAPIEnabled": false,
      "configuredBy": "john@contoso.com",
      "isRefreshable": true,
      "isEffectiveIdentityRequired": false,
      "isEffectiveIdentityRolesRequired": false,
      "isOnPremGatewayRequired": false,
      "isInPlaceSharingEnabled": false,
      "workspaceId": "5c968528-70b6-4588-809f-ce811ffa5c23"
    }
  ]
}

 I am unable to see the isOnPremGatewayRequired neither from powershell nor from the try it on the documentation. Strangely I am able to get that feature/key when using Datasets - Get Datasets In Group. Datasets - Get Datasets In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

[v-hashadapu]

Hi @mkjit256 , hope you are doing well.

Just wanted to know if your issue has been resolved through your support ticket with Microsoft? If so, we would greatly appreciate it if you could share the insights here, as they may benefit others with similar issues.

If you have any other queries, please feel free to raise a new post in the community. We are always happy to help. Thank you.

[mkjit256]

Hello i had open a ticket with MS, their update was that the Product Group team has acknowledged the problem and confirmed that they are actively investigating it. 

I will update once i get notified that the problem has been resolved.

[v-hashadapu]

Hi @mkjit256 , Thanks for the update. Please do share insights when your issue is solved.

[mkjit256]

MS confirmed the issue with the api response and they are working to fix it. It has been added to the schedule for a fix to be deployed. No definitive ETA on the fix, but tentatively it would be mid of January as they confirmed.

[v-hashadapu]

Hi @mkjit256 , thanks for the update.

[tayloramy]

Hi @mkjit256, 

Have you checked all the data or are you just spot checking? This is a JSON body, so it is possible that that field is just omitted when not True. 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

[mkjit256]

As you can see above, the field above shows even when the value is false, in addition, i did copy the response into a text editor and looked up for isOnPremGatewayRequired without finding a single occurence.

Note: The api call itself more than 5000 datasets. 

[tayloramy]

Hi @mkjit256, 

I just ran this API request in my tenant, and I'm seeing the same thing as you are.  isOnPremGatewayRequired is not appearing at all in the 5117 objects returned in my query. 

I'm starting to think there is something wrong, either in the documentation or in the API itself. 

I think this would be a reasonable bug report - at the very least the docs are wrong. 

I recommend raising a ticket with Microsoft so this can be reported as a bug. 

The gateway datasources endpoint does work to get all connections on a gateway, but it doesn't link them back to the semantic model at all. 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

[mkjit256]

Hello @tayloramy. Thanks for your effort, i had submitted a ticket to MS. I will update once i have a reply from their side.