Reports about powerbirestapi HOT 23 CLOSED

Could you please share with us more info about what function from the connector was used to trigger this error?
The field datasetId is being referenced in multiple parts of the Custom Connector, we don't really know which of the functions that references the datasetId is having the issue for your environment.

from powerbirestapi.

Hi Miguel,
Its blocking failing in Reports table in the custom connector

from powerbirestapi.

@klinejordan would you mind taking a look ? Can’t repro

from powerbirestapi.

Fixed - MSFT changed the behavior for Paginated Reports (now showing with a different report type and NULL dataset ID). @bsaragadam Can you validate?

from powerbirestapi.

yes, its working now
thank you

from powerbirestapi.

@migueesc123 / @klinejordan
Again failing with the same error for the paginated reports
Is there any change again from MSFT ??

from powerbirestapi.

I am not seeing any failures for paginated reports so I can't reproduce, can you post the error message you're getting?

from powerbirestapi.

from powerbirestapi.

Okay, are you sure you're still using the latest version of the connector? I can't reproduce that error, all my paginated reports return a NULL dataset ID as they don't have datasets (that's intended behavior)

from powerbirestapi.

@klinejordan Yes its working fine with the latest App and I have the other question to pull the data from Power BI Service Admin table do we need the both TenantRead.All/TenatRead.Write.All permission ??

I have tried with TenantRead.All permission and failing with the error message with 401 unauthorized.

could you provide the required permissions for the tenant level to extract the data

from powerbirestapi.

Per https://docs.microsoft.com/en-us/power-bi/developer/power-bi-permissions, you need to grant all permissions, not just read. We don't control what permissions are used and why, we're just following the documentation provided by MSFT.

from powerbirestapi.

Yes @klinejordan I have all the above permissions but its failed with Authentication while connecting to the Power BI Service admin table

from powerbirestapi.

For that section you need to be a Power BI service admin role. Are you able to get that role or elevate your privs?

from powerbirestapi.

@klinejordan Yes, I have the Power BI Service admin role but getting the above error.

from powerbirestapi.

Just added the fiddler error message from the fiddler while trying to load the Power BI Service Admin table from the connector

from powerbirestapi.

@klinejordan I'm having the Power BI Server Admin Role and Tenant.Read.All and Tenant.Write.ReadAll Role Permission role.. do we need any other permissions required.

from powerbirestapi.

The permissions your app registration needs is all documented here: https://docs.microsoft.com/en-us/power-bi/developer/register-app

But here's a screenshot of my app registration so you can try to match.

Also if you're Power BI Service Admin role is a Just In Time privilege (meaning you have to elevate each time you use it - some tenants are configured like this including mine) make sure you've elevated it, not just eligible:

from powerbirestapi.

@klinejordan
I have verified the above permissions and we have all the required permission but We don't have Privileged Identity Management License to our tenant Is there any other way we can elevate the permission or do we need compulsory PIM for Power BI service admin to get this custom connector to work ??

from powerbirestapi.

@klinejordan do you have any update ?? If we dont have the PIM License and we cannot fetch the data for Power BI service admin table ?? We are the Power BI Service Administrator role but not using the PIM ..

from powerbirestapi.

You don't need PIM to get this to work - i mentioned it because some tenants have it and some don't, and some people forget that they need to activate it, not just be eligible for the role.

I'm not sure I can fix your issue at this point - you may have other networking or authentication or trust settings I'm not aware of, but supporting this connector isn't my full time job.

from powerbirestapi.

hey @bsaragadam !

This repo is mainly taking bugs related to the custom connector itself. To be more specifically, anything that is not working as intended because of something that is just awfully written in our code (usually my fault).

The custom connector was created as a community effort and is provided as is with no warranty under the MIT license, which means that you can also fork it and customize to your needs in the event that you see anything that is missing.

As @klinejordan has said, this appears to be an issue related to permissions on your tenant and not something related to our Custom Connector. I'd highly recommend that you get in touch with your Power BI Admin and provide the pictures that you've seen before in this thread as an example in terms of permissions that should be available in your app for this to work.

We are not the owners of the data source, so we are unable to provide any diagnostics or further help as to what's happening with your specific case. Ultimately if your Power BI Admin needs further help, I'd recommend that he / she gets in touch with Microsoft to look further into it.

We thank you for reporting the original bug and if you find any other bug or errors in the dataset, please let us know.

from powerbirestapi.

@migueesc123 @klinejordan Thanks for the prompt response.. @klinejordan do you use the MFA for your tenant ?? I'm thinking its blocking for me due to MFA or ADFS Authentication

from powerbirestapi.

Hi!
The missing piece in my case was "Grant Admin Consent"

Thanks for all the awesome work with this connector

from powerbirestapi.