Forum Discussion

sgunnam01's avatar
sgunnam01
Frequent Visitor
4 years ago
Solved

Error while connecting to AmazonAthena gateway. We cannot convert the value null to type Record.

Hi  I have setup a OnPremise data gateway to pull data into Power BI service via Amazon Athena. I configured the Gateway by installing Athena ODBC driver in the machine and the test connection fro...
Need Help
  • sgunnam01's avatar
    sgunnam01
    4 years ago

    Finally I could solve this problem. Thanks for everyone who tried to help. Incase if others face the same issue, below is how it is setup for us.

     

    1. Install the gateway and Athena ODBC connector on a ODBC machine. We DO NOT need to put this in Customer connectors. 

    2. Give the role based permissions (based on how you want your authentication) to the machine where above two components are installed. Make sure you are able to connect from ODBC to datasource by doing "Test Connection" in ODBC configuration dialog. There we used Authentication mechanism as "Default". 

    3. When creating "Datasource" in Power BI service using the "gateway" name that was setup in step1, selection the authentication as anonymous.

    This should create the datasource successfully.  

     

sgunnam01's avatar
sgunnam01
Frequent Visitor
4 years ago

Hi 

 

Thanks for your response. Does it mean everyone who is using Power BI Athena Gatway is facing this issue? How do it know if I have configured everything correctly? I could not find any documentation on how to configure Athena for Power BI gateway. It would be of great help if you can share any documentation or details steps on how to configure it. BTW I have set up the Power BI gateway on the Windows server machine. 

 

-sandeep