Forum Discussion
PowerBI Embedded problem with Direct Query on Azure SQL
Direct Query is supported for the Embeded and you would need to configure the datasource after the import, here is how: https://msdn.microsoft.com/library/mt711498.aspx
https://azure.microsoft.com/en-us/documentation/articles/power-bi-embedded-get-started/
Hope this helps,
Irina
Thanks for the hint!
After setting the credentials using the Path Gateway Datasource operation it's working fine.
Hello,
how do I configure the Path Gateway Datasource. Searched for it but with no luck.
Thanks in advance.
Hello,
I solved it myself. My problem was that I had to update my credentials for my existing dataset. Just select point 7 at the Provision Sample located at the Power BI Embedded sample and enter your credentials for the SQL Server. Updating the connection string was not necessary so I skipped it.
Where exactly do you set the Path Gateway Datasource?
Hello,
I don't know if I configured the Path Gatewy Datasource. But if you want to upload your .pbix-report to your web application you can use the Provision-Example (Provision-Sample). At first you have to upload your example-report (Provision-Sample: Nr. 5). After that you have to update the connection string, because it seems that the credentials you have entered before are not applied to the report uploaded to your web-app. So just select Nr. 7 of the Provision-Smaple and enter your credetials for your database. Then the report should show the data from the database.
