PowerBI Embedded: Datasource has no credentials, unable to Patch the gateway
<p>I wanted to test out PowerBI embedded so I downloaded the <a href="https://github.com/Azure-Samples/power-bi-embedded-integrate-report-into-web-app/" rel="nofollow noreferrer">the sample app</a> that is able to publish a pbix file and to embed it.
So I created the easiest PowerBI file one is able to make with Azure SQL, using the DirectQuery option, as underlying data source.</p>

<p>I succesfully imported the PowerBI file in my workspace collection
<a href="https://i.stack.imgur.com/uZuzZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uZuzZ.png" alt="enter image description here"></a></p>

<p>I changed the connection string of my PowerBI file succesfully
<a href="https://i.stack.imgur.com/2qEMZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2qEMZ.png" alt="enter image description here"></a></p>

<p>After that the code to patch the gateway with the username and password credentials fails
<a href="https://i.stack.imgur.com/D2kMg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/D2kMg.png" alt="enter image description here"></a></p>

<p>Then when I tried to view the embedded report I got this error. 
<a href="https://i.stack.imgur.com/zWZDo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zWZDo.png" alt="enter image description here"></a></p>

<p>I believe the connectionstring is in the correct format because it was updated succesfully. I also already tried to point it to another SQL database and then the error shows the other SQL database in the error message.</p>

<p>1) I thought this could be <a href="https://stackoverflow.com/questions/37745252/powerbi-embedded-dmts-datasourcehasnocredentialerror">because the Gateway does not get the credentials</a> that I gave it is that correct? 
2) Does someone know how can I fix this?</p>

<p>Thanks in advance!</p>