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.
Hi,
Im trying to connect to amazon redshift via the ODBC connector in dataflows but am experiencing an issue where the service keeps asking me to edit credentials when I use a SQL statement.
If I dont use a statement, I am able to navigate through the folders and access the smaller tables, however the table I am trying to get at has 50 million rows so I need a SQL statement to cut it down.
I have tried anonymous, organisational, basic and windows but none seem to be working. Frustratingly, I am certain it was working earlier this morning but now is not.
Thanks
Solved! Go to Solution.
Found the issue. Need to leave the DSN dropdown blank.
Found the issue. Need to leave the DSN dropdown blank.
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.