topic Re: How to embed pbix which is connected to redshift? in Developer

How to embed pbix which is connected to redshift?

HarRuc — Mon, 31 Oct 2016 04:07:38 GMT

I am new user of PowerBI trying to embed reports on web-app using this sample code https://github.com/Azure-Samples/power-bi-embedded-integrate-report-into-web-app/

I was able to succesfully create pbix file using PowerBI desktop, and create workspace. But when I follow step 7 "update connection string info for existing dataset" and provide jdbc or odbc connection string provided by AWS redshift which looks like this Driver={Amazon Redshift (x64)}; Server=servername.cecf14nmvqna.us-west-2.redshift.amazonaws.com; Database=dbname; UID=username; PWD=password; Port=5439

I am getting following exception

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\username\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

Does anyone know what might be wrong here?

Re: How to embed pbix which is connected to redshift?

Sunkari — Mon, 31 Oct 2016 09:46:05 GMT

I don't think Power BI Embedded is currently supporting Redshift

Re: How to embed pbix which is connected to redshift?

HarRuc — Mon, 31 Oct 2016 13:57:32 GMT

Its a bummer 😞 given lack of tools to easily bulk import tools for MS Azure SQL or SQL data warehouse I had to look into redshift (where there are tonnes of great tool for bulk upload) but then now pbix embed is not supported for aws redshift.......

Re: How to embed pbix which is connected to redshift?

knov99 — Sun, 05 Feb 2017 06:33:20 GMT

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#M15037
https://community.powerbi.com/t5/Integrations-with-Files-and/Scheduled-Refresh-from-Amazon-Redshift/m-p/50587#M4404

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.

Re: How to embed pbix which is connected to redshift?

kiran_mahadev — Fri, 07 Jul 2017 11:20:02 GMT

Any updates on this yet?