Forum Discussion

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi catcollector ,

This behavior is not limited to Power BI, had the same problem in Excel. It could be either the Driver's limitation or something to do with the Driver-AWS interaction.

Here'a an exact same issue as you, the workaround is on the 'From ODBC' window where one is presented and prompted to select 'DSN', there's also an 'Advanced options' selection. Expand the 'Advanced options' selection pane, and fetch desired data by giving an SQL query in the 'SQL Statement' box.

Hope it helps!

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

catcollector's avatar
catcollector
Helper I
4 years ago

v-yanjiang-msft I think I have located the connect to data source screen where I can add an SQL statement. Would you be able to tell me how I can fetch data from other catalogs in Athena? We currently have two other cross account catalogs. Where can I locate the statement to fetch these catalogs? Thank you!