Facing issue embedding redshift connected pbix

[HarRuc]

Using this sample code https://github.com/Azure-Samples/power-bi-embedded-integrate-report-into-web-app/ I was able to create workspace and was able to also create pbix directquery connected to redshift.

But when executing 'update connection string for existing dataset' step , i m getting below error. I used AWS Redshift ODBC connection string and master username and password for it

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\ruchit\Desktop\power-bi-embedded-integrate-report-into-web-app-master\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\ruchit\Desktop\power-bi-embedded-integrate-report-into-web-app-master\ProvisionSample\Program.cs:line 235

I wonder what might be the issue? I hope redshift connected pbix files can be published to azure workspace for embed experieces

[v-ljerr-msft]

Hi @HarRuc,

As connecting to Amazon Redshift is just a Preview feature in Power BI Desktop, I don't think it is supported for Power BI Embed currently. Here is a similar thread for your reference.

Regards

[knov99]

This solution is still needed. The Redshift connector was announced here:

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-connect-redshift/
https://powerbi.microsoft.com/en-us/blog/building-power-bi-reports-on-top-of-amazon-redshift-data/

This last article, dated Aug 1 2016, said the Redshift connector doesn't yet work for "Power BI Gateway or PowerBI.com for refresh scenarios, which will come in the next couple of months."

These threads have essentially the same issue:

http://community.powerbi.com/t5/Service/Redshift-dataset-Refresh-not-working/m-p/97473#M16455
http://community.powerbi.com/t5/Developer/Redshift-in-Power-Bi-Embedded/m-p/55925#M1763
http://community.powerbi.com/t5/Service/Facing-issue-embedding-redshift-connected-pbix/m-p/83979#M15...
https://community.powerbi.com/t5/Integrations-with-Files-and/Scheduled-Refresh-from-Amazon-Redshift/...

It's been six months since "a couple of months" was promised. Any news? This is a big issue for my application, where I need to do scheduled refreshing in the PBI service, just like any other database.