Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power BI Embedded With Service Principal

Hi All,   We are using Power BI Embedded and we have an dedicated capacity created with A1 Scale. So whether we will be able to embedded the reports to our application without Purchasing Power BI ...
Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi Anonymous ,

    You can refer the second tutorial that I have previously post, it explains it in details.

    Here is another document about using service principal: Embed Power BI content with service principal and an application secret 

    Please note that: 

    If you're using service principal, you can publish reports to the new workspaces using the Power BI REST APIs.

     

    If you have any other problems, please kindly let me know and l'm willing to help you to solve this issue.

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

alanatnfa's avatar
alanatnfa
Frequent Visitor
3 years ago

Hello v-yingjl

 

I am hoping you can help me!  I have spent a week attempting to get an embedded pagingated report working and cannot.  I can use the method correctly for a power bi report - working great and have this rendering within the sandbox app.

 

The permissions all look correct, the paginated report I am using is a power bi data set.  If I publish a report with data entered within the report, that works correctly and renders.  If I publish a report with no data set - works fine.  As soon as I use a dataset, and I have also tried using the XMLA endpoints, I fail and receive the following error

 

There was an error contacting an underlying data source. Manage your credentials or gateway settings on the management page. Please verify that the data source is available, your credentials are correct and that your gateway settings are valid.

 

If you are able to help it would be greatly appreciated.

 

Thanks

 

gpiauilino's avatar
gpiauilino
Frequent Visitor
3 years ago

Hello alanatnfa !

Only a powerbi admin user in your company will be able to access the settings in the AdminPortal, and it is also worth remembering that if you want to apply the capacity to other Workspaces, you will also need to have additional access to the Capacity in Azure.

Check in your company who would be the "PowerBI Admin" person and ask for help to enable API Access.

Lastly, give access to the service principal as a Workspace admin (just as you add a collaborator, you can also search for the service principal name.)

If the problem has not been resolved, check in Azure if the service principal has the necessary accesses for what you need (PowerBI APIs).

 

Hugs!