We cannot convert the value null to type Record

[Tech02]

I am getting the below error while trying to refresh it on power Bi service.

The data is connected through AWS Athena.The gateway status is showing online  and running state.When I refresh it through Power Bi desktop it's working fine. There are no null values in the data. I am not sure how it fix this issue. Anyone can suggest what could be the issue.

[Netope]

I had the same issue and I found a work around that worked for me, not sure if it applies to all cases but you can try. In power BI Desktop go to Transform Data --> Data Source Settings, right click on Amazon Athena and select clear permissions. After that I was able to refresh data again. Hope this helps

[Anonymous]

Hi @chizuml_ds,

I had the same issue and I figured out the reason it was happening. When you mention your DSN in the Amazon Athena (Beta), the next thing it will ask is your login (which has two options).Do not take the 2nd option. Pick the first option where the all setting are pulled from your DSN settings, which you did to setup your datasource.

Now if you once did it wrong, It won't ask you again the same things to fix it. Create a new powerbi file and do the steps.

amazon web services - PowerBI Athena Beta Connector Details: "We cannot convert the value null to ty...

If it still does not help, We suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/

Best Regards

Community Support Team _ Polly

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

[Tech02]

I had follwed the steps that you have suggested but it didn't resolve the issue. 

[Anonymous]

Hi @Tech02 ,

If it still does not help, We suggest you to open a ticket here for help if you are a pro  user :  https://powerbi.microsoft.com/en-us/support/

Best Regards

Community Support Team _ Polly

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

[chizuml_ds]

Thanks CST, but not real helpful when the data source is out of our control.
It gives the perception that Microsoft helped this to happen when WE want to pull AWS data ourselves (and not pay the 1% of all cloud costs when Azure does it).

[Anonymous]

Hi @Tech02 ,

The error message means that you need to change null value to other values when you change data type.

I have found a similar post, pelase refer to it to see if it helps you.

Solved: [Expression.Error] Cannot convert the value null t... - Microsoft Power BI Community

• I worked around it, by modifying the data source. Here is my post on another site, where I explain how I did it: https://stackoverflow.com/questions/72735648/power-query-expression-error-cannot-convert-the-value-n...

If it still does not help, please provide more details.

Best Regards

Community Support Team _ Polly

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

[chizuml_ds]

I have the same error while attempting to connect to Amazon Athena with Power-BI.

Details: OnPremDataGatewayEnterprise: We cannot convert the value null to type Record. Please have this information handy if you choose to create a support ticket. ActivityId: 486bd157-3379-401a-83d0-b3e94103422e RequestId: 497bce5f-cab4-4ad7-b156-2d5cfabf6e57 Cluster URI: https://api.powerbi.com Status code: 400 Time: Wed Nov 16 2022 10:10:25 GMT-0500 (Eastern Standard Time)