Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Mukesh_Patel
Frequent Visitor

API call to Paginated Report using Service Principal profile gives error "PowerBIEntityNotFound"

 

Hello,
I am receiving the following error while making an API call to a Paginated Report using a Service Principal profile. 
The paginated report is published in a Premium Per User Workspace.

 

Mukesh_Patel_1-1717096384182.png

 

2 REPLIES 2
v-yiruan-msft
Community Support
Community Support

Hi @Mukesh_Patel,

The “PowerBIEntityNotFound” error typically indicates that the entity (in this case, the Paginated Report) could not be found. Could you please check the following info?

1. Make sure that the report ID and workspace ID are correct

How can I embed a Power BI report that contains a paginated report visual?

To embed a Power BI report that contains a paginated report visual with the embed for your customers method, use a service principal and embed the report with a multi-resource embed token, that contains the following:

  • Power BI report ID
  • Paginated report ID (of the report the visual is connected to)
  • Dataset ID (of the Power BI report)

The service principal must have access to both reports (paginated and Power BI).


Solved: Re: Power BI Embed - issue with Paginated report v... - Microsoft Fabric Community

2. Get the correct embed token: If you have a paginated report with a Power BI dataset as a data source you should use V2 embed token (AKA multiresource embed token), which are generated using the Power BI REST APIs.

Solved: Embedding paginated reports error: Unable to rende... - Microsoft Fabric Community

This error usually means that the embed token wasn't generated correctly.

If you have a paginated report with a Power BI dataset as a data source you should use V2 embed token (AKA multiresource embed token), which are generated using this API Embed Token - Generate Token - REST API (Power BI Power BI REST APIs) | Microsoft Learn. The request should include the dataset ID and like this example Embed Token - Generate Token - REST API (Power BI Power BI REST APIs) | Microsoft Learn


3. Make sure that the service principal profile is set up correctly

Use service principal profiles to manage customer data in multitenant apps - Power BI | Microsoft Le...

Best Regards

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

Hello Rena,
Thank you for the reply. I'm sharing more details about the process we are using

We are calling the POWER BI Paginated REST API (POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/ExportTo) from the azure func...

We have carried out the following steps:

  1. Created a service principal in Entra ID (we have created a new app registration)
  2. Provided all the Power BI service permission to it.
  3. Created a Security Group in Entra ID and added the service principle as member.
  4. On the Power BI side, we have provided Admin level access on Workspace level to the service principal. 
  5. On the Admin Portal on power BI we have enabled the below setting. 
    Mukesh_Patel_4-1717165584362.png

     

     

    1. Now we are generating the token as below

    Mukesh_Patel_5-1717165621448.png

     

     

     2. This is the way we are trying to call the API and getting "PowerBIEntityNotFound" error.

    The paginated report is published in a Premium Per User Workspace. 

     

     

    Mukesh_Patel_2-1717165348416.png

     

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.