The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hi, I'm having difficulty setting up Power BI Embedded sample app for a dashboard. I used the sample app to upload the PBIX file, which has only two tables imported from Azure SQL using Direct Query. I provisioned the Workspace Collection and created workspace, and updated the web.config with relevant information. When I run the Power BI embedded sample web application, it shows the dashboard and correct titles for the visuals. However, it doesn't render the visuals (technical details show 401 error). I have specified the connection string using the sample app. When I publish the PBIX file to powerbi.com, I need to manually enter the credentials when viewing the dashboard. Has anyone faced a similar problem? Please help.
Did you configure the credential for the dataset that using direct query in Power BI Embedded?
The visual is rendered with data after setting the username and password.
User | Count |
---|---|
17 | |
2 | |
2 | |
2 | |
1 |
User | Count |
---|---|
20 | |
10 | |
5 | |
4 | |
3 |