Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
HarRuc
Regular Visitor

How to embed pbix which is connected to redshift?

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?

 

4 REPLIES 4
kiran_mahadev
Regular Visitor

Any updates on this yet?

Sunkari
Responsive Resident
Responsive Resident

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

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.......

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.

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.