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.
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 🙂
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.