cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
brett_walton
Helper II
Helper II

ERROR [HY000] [Simba][RedShift ODBC] (30) connecting to Redshift

When connecting to amazon redshift I get the following error when trying to access the data in preview mode during an import. All tables I access have the same result. These tables are accessed by other BI tools (Tableau) with no issues. 

 

DataSource.Error: ODBC: ERROR [HY000] [Simba][RedShift ODBC] (30) Error occurred while trying to execute a query: ERROR: syntax error at or near "from"
LINE 2

 

Maybe this is a Beta issue , any ETA on the polished Redshift connector ? 

 

thanks 

1 ACCEPTED SOLUTION

It should be in the latest one. The issue I was guessed, was the case where the user doesn't have access to the columns. Have you checked that? If that's not the case, this is a new issue. In that case can you please send us a frown email with the traces?

(Enable tracing from Options > Diagnostics > Enable Tracing (Verbose) (also you can open the Traces folder from here), then reproduce the failure, then close the PBI Desktop. You can get the traces from Traces folder.)

View solution in original post

3 REPLIES 3
arify
Microsoft
Microsoft

I think we've fixed this issue, it should be in the next release. It was happening when the user doesn't have access to the table (or, its columns). Just to check if it's the issue I'm thinking: does your user have read access to the table?

 

Thanks

Any idea what month that release will be ?

It should be in the latest one. The issue I was guessed, was the case where the user doesn't have access to the columns. Have you checked that? If that's not the case, this is a new issue. In that case can you please send us a frown email with the traces?

(Enable tracing from Options > Diagnostics > Enable Tracing (Verbose) (also you can open the Traces folder from here), then reproduce the failure, then close the PBI Desktop. You can get the traces from Traces folder.)

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.