Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is it possible to use an adhoc query while connected to a redshift database? I can't seem to figure this out.
Solved! Go to Solution.
@donrickman,
When using the Amazon redshift connector in Power BI Desktop, it is not possible to write queries, we are only able to input server name and database name to get data from Amazon redshift.
As a workaround for this issue, you can create a ODBC data source for Amazon redshift following the guide in this video, then connect to the ODBC data source in power I Desktop, and you can write queries in SQL statement textbox.
Regards,
Lydia
@donrickman,
When using the Amazon redshift connector in Power BI Desktop, it is not possible to write queries, we are only able to input server name and database name to get data from Amazon redshift.
As a workaround for this issue, you can create a ODBC data source for Amazon redshift following the guide in this video, then connect to the ODBC data source in power I Desktop, and you can write queries in SQL statement textbox.
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |