cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GerwinG New Member
New Member

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 direct query report. 

 

There is:

Option 7: update connection string info for an existing dataset

 

Does anyone know what we need too fill in there?

Connection is too a SQL server with 1 DB

 

 

19 REPLIES 19
gjross Frequent Visitor
Frequent Visitor

Re: PowerBI Embedded Sample Connection string

Did you manage to resolve this? I am struggling to get a format for the connection sring that works to a SQL DB in Azure.

Highlighted
pritesho Regular Visitor
Regular Visitor

Re: PowerBI Embedded Sample Connection string

I have had the same issue though just fixing User Id and password was enough for my case.  You may want to just switch database pointing in local PowerBI Desktop and just update the credentials from Sample - Option 7-Gateway update.

Nithya Frequent Visitor
Frequent Visitor

Re: PowerBI Embedded Sample Connection string

Hi,

if you give connection string like below it will work 

 

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

TheEdcomm Frequent Visitor
Frequent Visitor

Re: PowerBI Embedded Sample Connection string

I tried using same format but still getting following error - 

 

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:\Projects\PowerBi\sample\Project\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:\Projects\PowerBi\sample\Project\ProvisionSample\Program.cs:line 235

AnuragR Frequent Visitor
Frequent Visitor

Re: PowerBI Embedded Sample Connection string

Did you get the issue resolved?
I am stuck at same place with same exception

Please share a solution

Thanks

AnuragR Frequent Visitor
Frequent Visitor

Re: PowerBI Embedded Sample Connection string

Hello I have been facing the same issue . Please share if it was resolved.
The Provision Sample was working fine but two days back it threw this exception exception and continues to do so , with the same connection string :

"data source=XXXX.database.windows.net;initial catalog=XXXX;"

 

lsingh Frequent Visitor
Frequent Visitor

Re: PowerBI Embedded Sample Connection string

Hi,

 

i have a similar issue..

can you please provide an udpate? 

 

I am trying to connect my power BI to > AWS windows machine as a gateway > this connects to AWS RDS to allow data refreshes....

 

I have set up an ODBC on AWS Windows machine and configured it....but when trying to link my POWER BI Gateway to my AWS machine it does not let me add data source

zemag Frequent Visitor
Frequent Visitor

Re: PowerBI Embedded Sample Connection string

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 Frequent Visitor
Frequent Visitor

Re: PowerBI Embedded Sample Connection string

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!

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 6 members 3,714 guests
Please welcome our newest community members: