Forum Discussion
AWS Athena -PowerBI Desktop: Error - We cannot convert the value null to type Record
Hi Hatim ,
According to your description, you mentioned type Record, according to which you seem to be using advanced editor to link to AWS Athena, and at the same time performing data type conversion in advanced editor, first of all you can make sure that there are no null values. Please provide us with the complete code in the advanced editor after you have ruled it out for us to troubleshoot.
Please remove any sensitive data in advance.
Best regards
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
I have double checked the CSV file for the null values and there are none. There seems to be some other issue since the old file, which was working perfectly well is also not working. There is something at connection level. The PowerBI service is working fine with both (old and new) CSV files. The issue is only with desktop version.
I have been also checking the net and found others also had same issue and was not releated to null values. The solution in the link below did not work for me.
CREATE EXTERNAL TABLE `budget`( `app` string, `time` int, `amount` float) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' LOCATION 's3://costdata-/Budget Info CSV' TBLPROPERTIES ( 'classification'='csv', 'transient_lastDdlTime'='xx')