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

How do I create an advanced SQL query with an AWS Redshift database in powerbi service

I am basically self teaching how to use powerbi service and I am absolutely lost. 

 

All of my data is stored in a redshift cluster after hours of trying to figure things out I managed to get a data gateway up and running.

 

So I go to create a data flow using the redshift connector and get to the following page 

TCFPA_0-1673370989271.png

I do not see an option to add my SQL query to the connection as I do when I set up the connection in desktop. Can I add an SQL query?

 

I tried to use ODBC as it has an SQL editor but I get a different error. I am doing something wrong with this connection string I believe

 
 

image.png

 

1 ACCEPTED SOLUTION
collinq
Super User
Super User

Hey @TCFPA ,

 

I think that this article will help you with all of the steps:

Connecting the Microsoft Power BI service to AWS data sources - Using Microsoft Power BI with the AW...

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

2 REPLIES 2
collinq
Super User
Super User

Hey @TCFPA ,

 

I think that this article will help you with all of the steps:

Connecting the Microsoft Power BI service to AWS data sources - Using Microsoft Power BI with the AW...

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




TCFPA
Frequent Visitor

Yeah I had to set up a gateway on an EC2 server then add ODBC to it for me to do an advanced query. My main issue was that the redshift connector in desktop allows for an SQL query while the online version does not. The only way to get around this was instead using ODBC

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors