Forum Discussion

GerwinG's avatar
GerwinG
New Member
10 years ago

PowerBI Embedded Sample Connection string

I've been testing with the PowerBI Embedded sample files. https://azure.microsoft.com/nl-nl/documentation/articles/power-bi-embedded-get-started-sample/   Everything is working fine except a direc...
Need Help
zemag's avatar
zemag
Regular Visitor
9 years ago

I am also getting the same error message: "Bad Request" (see stack trace below) and I'm not really sure why.

 

After adding the new dataset (pbix file) I then execute #7, enter Username and Password (I'm assuming this is the same username and password used to connect to, in my case, the Azure SQL Database) and then enter the connection string with the server and database.  I entered the connection string in two different ways to no avail:

 

Data Source=xxxx.database.windows.net;Initial Catalog=dbName;User ID=xxx;Password=xxx;

 

and also:

 

Data Source=xxxx.database.windows.net;Initial Catalog=dbName;

 

I also deleted the published dataset and imported it again, but nothing.

 

Is there an updated version of the ProvisionSample code???

 

Ooops, something broke: Microsoft.Rest.HttpOperationException: Operation returned an invalid status code 'BadRequest'
at Microsoft.PowerBI.Api.V1.Datasets.<SetAllConnectionsWithHttpMessagesAsync>d__15.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Api.V1.DatasetsExtensions.<SetAllConnectionsAsync>d__21.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
at ProvisionSample.Program.<UpdateConnection>d__27.MoveNext() in C:\Users\EduardoGamez_vheyphg\Documents\Visual Studio 2015\Projects\PowerBI Embedded\ProvisionSample\Program.cs:line 592
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.GetResult()
at ProvisionSample.Program.<Run>d__17.MoveNext() in C:\Users\EduardoGamez_vheyphg\Documents\Visual Studio 2015\Projects\PowerBI Embedded\ProvisionSample\Program.cs:line 235

  • zemag's avatar
    zemag
    Regular Visitor
    9 years ago
    I figured it out! It appears that Power BI Embedded doesn't like it when you regular PBI data sets (I.e. Import type of connection not direct query) and direct query data sets. I removed this other data set from the workspace and imported my direct query data set. I then added the connection string by first specifying the username and password and then providing the connection string with the Data Source and Initial Catalog only. I did not get an error message but a confirmation that it was accepted. I went to my web app and I was able to access the embedded dashboard as expected. I hope this helps!

    Power BI team - if you can please update the sample code with this important fact?

    Thanks!