Forum Discussion
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.
2 Replies
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
Best Regards
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 function to get the report in excel format.We have carried out the following steps:
- Created a service principal in Entra ID (we have created a new app registration)
- Provided all the Power BI service permission to it.
- Created a Security Group in Entra ID and added the service principle as member.
- On the Power BI side, we have provided Admin level access on Workspace level to the service principal.
- On the Admin Portal on power BI we have enabled the below setting.
1. Now we are generating the token as below
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.
