Connect Athena with Power BI Before the data import for finished, its data source timed out.

[kamaljeetsingh]

Need Help - 

What is done ?

1. ODBC Athena driver is installed in one of the RDP and DSN is configured having Athena specification - So far good and test connection successfull with no issue  
2. Gateway is installed in the same above RDP and it is running with no issue. 
3. Built successfull ODBC (for AWS Athena) connection in Power BI Service Gateway. No Issue
4. Attached above connection to the Power BI dataset. No Issue
5. When did the adhoc Refresh of one of the PBI Report, the refresh kept rolling for 2 hours and finally it ended with "Before the data import for finished, its data source timed out. Double-check whether that data source can process import queries, and if it can, try again." - This is the problem statement  

Additional Info - 

1. Power BI Report above is having small 1 table (containing 1000 rows).
2. Below are some additional error from Mashup file generated from Gateway Log 
   1. "NonFatalError":"Could not find a part of the path 'C:\\Users\\PBIEgwService\\AppData\\Local\\Temp\\Microsoft\\MashupProvider\\Temp'
   2. "NonFatalError":"Could not find a part of the path 'C:\\Users\\PBIEgwService\\AppData\\Local\\Temp\\Microsoft\\MashupProvider\\Cache
   3. "NonFatalError":"ERROR [HY096] [Simba][ODBC] (11180) SQLGetInfo property not found: 180. An error occurred but no ODBC error information was available"

 

[kamaljeetsingh]

Just adding another FYI note - 

Published Report is using import through ODBC AWS Athena  

[kamaljeetsingh · Accepted solution]

Thanks for the help!

I re-tried today and i was able to locate the problem and it was due to SQLGetInfo property

Solution: There could be 2 which I was able locate so far:-

1. Enable port 444 for optimal performance.
2. Disable ODBC “Use Resultset Streaming” (DSN Configuration --> Advance Option --> Use Resultset Streaming) – this is not recommended for huge data