Forum Discussion
We cannot convert the value null to type Record
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.
7 Replies
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)
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.
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).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.
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.
I had follwed the steps that you have suggested but it didn't resolve the issue.
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.
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
