Forum Discussion

visheshjain's avatar
visheshjain
Impactful Individual
1 year ago
Solved

ODBC error for data source AWS Athena

Hello everyone,   I have a AWS Athena as my source for the data and I am getting the following error in PBI Desktop.   Everything works alright until I change the data type to whole number on one...
Need Help
Show and Tell
Tips and Tricks
  • visheshjain's avatar
    visheshjain
    1 year ago

    The suggested solutions did not work and also look like they were copied from generative AI models.

     

    At the moment the ODBC connection is quite slow and even after updating the connector to v2 it only slowed down the refresh time.

     

    I am going to try to move the data source to a Fabric Lakehouse or Azure SQL to see if the refreshes take lesser time.

     

    Thank you,

v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
1 year ago

Hi visheshjain,

We wanted to see if the information we gave helped fix your problem. If you need more help, please feel free to contact the Microsoft Fabric community.

Thank you.

visheshjain's avatar
visheshjain
Impactful Individual
1 year ago

The suggested solutions did not work and also look like they were copied from generative AI models.

 

At the moment the ODBC connection is quite slow and even after updating the connector to v2 it only slowed down the refresh time.

 

I am going to try to move the data source to a Fabric Lakehouse or Azure SQL to see if the refreshes take lesser time.

 

Thank you,