Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
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
Solved! Go to Solution.
Hey @TCFPA ,
I think that this article will help you with all of the steps:
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hey @TCFPA ,
I think that this article will help you with all of the steps:
Proud to be a Datanaut!
Private message me for consulting or training needs.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
28 | |
24 | |
23 | |
20 |
User | Count |
---|---|
55 | |
35 | |
23 | |
22 | |
20 |