Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am trying to configure a connection through to AWS Athena via an On-Premises Data Gateway.
When the connection tries to do its test, I get the following error message:
We cannot convert the value null to type Record
I am using OAuth2 as the Gateway Authentication.
Within the ODBC Connection, I am using IAM Credentials.
The ODBC connection that I setup works fine from the device through to AWS Athena. I can also connect via Power BI Desktop and return data.
Does anyone have any clue?
Thanks
Solved! Go to Solution.
I have resolved the issue.
For reference, here is what I needed to do to make it work:
Once I had these settings sorted, the connection worked.
I have resolved the issue.
For reference, here is what I needed to do to make it work:
Once I had these settings sorted, the connection worked.
Hi @Anonymous
Maybe you can try the method provided by sgunnam01
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.
Solved: Error while connecting to AmazonAthena gateway. We... - Microsoft Power BI Community
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thanks for the tip. While it hasn't 100% solved the issue, it has made me look at how it was setup again and I have now been able to figure it out.
I will post my fix, for reference in another reply
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.