migueesc123 / PowerBIRESTAPI

A Microsoft Power BI Data Connector or Power Query Connector for the Power BI REST API
MIT License
238 stars 74 forks source link

Get Dataset Users doesn't work #152

Open Alvarocarrasan opened 1 year ago

Alvarocarrasan commented 1 year ago

Hi!

First of all, thank you for this connector, it's really hepful!

I'm trying to get the users that can access a dataset, but the API doesn't work, it never finishes getting the data. Maybe there is a problem with the connector or is it an API problem?

image

Regards.

migueesc123 commented 1 year ago

Hey!

I'd recommend starting with looking at the responses that you're getting from the API to see what could be happening. You could use something like Fiddler to trace those calls and responses.

The connector basically just reaches the API and exposes whatever it is that we receive.

klinejordan commented 1 year ago

If you're in a larger tenant there's a chance that API call will timeout or your token will expire since it has to loop through every dataset in the tenant individually and that can take some time. That's exactly why its in the "Experimental" folder because we cannot guarantee performance in large tenants.

How many datasets are in your tenant? You can use the Get Datasets As Admin query to find this