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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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