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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
KevinS
New Member

PowerBI Embedded Service 403

Hi, 
I'm trying to follow a series of tutorial from Microsoft's github for using PowerBI Embedded Service in Azure.
Source code for client side (html + javascript using fetch): https://github.com/Microsoft/PowerBI-JavaScript/tree/master/demo

Source code for API code (node.js): https://github.com/Azure-Samples/powerbi-node-server-express

 

For API, I'm practically just changing my Workspace ID and Access Key.

Workspace and sample report(.pbix) has been created and uploaded using CLI from https://github.com/Microsoft/PowerBI-Cli.

 

However, I'm getting a 403 response when trying to load the embedded report. The PowerBI widget shows fine, just the report that failed to load and showing 403 when calling https://wabi-south-east-asia-redirect.analysis.windows.net/powerbi/metadata/models/674839/?modelOpti....

Here is the request ID: 8261be22-6a6d-a69e-9408-613a00829b10
Is there anything that I'm missing here?

Really appreciate your quick response 🙂 

1 ACCEPTED SOLUTION
KevinS
New Member

I've solved it.

Even though the report is working fine in PowerBI Desktop using DirectQuery to Azure, it turns out that our connection string and credentials are not carried over to PowerBI Embedded Service when we upload our PBIX.

Therefore, we should run the "Patch Gateway" API as defined in https://msdn.microsoft.com/en-us/library/mt711498.aspx
A little help in form of CLI has been created by Microsoft fellow, and can be found at https://github.com/Azure-Samples/power-bi-embedded-integrate-report-into-web-app.
We just need to compile it and run menu number 7.

View solution in original post

1 REPLY 1
KevinS
New Member

I've solved it.

Even though the report is working fine in PowerBI Desktop using DirectQuery to Azure, it turns out that our connection string and credentials are not carried over to PowerBI Embedded Service when we upload our PBIX.

Therefore, we should run the "Patch Gateway" API as defined in https://msdn.microsoft.com/en-us/library/mt711498.aspx
A little help in form of CLI has been created by Microsoft fellow, and can be found at https://github.com/Azure-Samples/power-bi-embedded-integrate-report-into-web-app.
We just need to compile it and run menu number 7.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors