Forum Discussion
Is there a work around for this Cannot convert literal to 'Edm.Decimal error
I keep getting this error when I try to connect to table in Power BI via OData connector. when I remove fields with decimals from the table the error goes away but when I add them back I get the below,
Error: Data Source Error : DataSource.Error: OData: Cannot convert the literal '4.34434343545435E+16' to the expected type 'Edm.Decimal'. DataSourceKind = <ccon>OData</ccon> DataSourcePath = <ccon>
I need decimals fields. Is there a work around? or way to fix issue?
Hi Anonymous ,
According to the error message, it seems to be a data type convert error. Could you please provide some sample data in the decimal field for the further troubleshooting? And you can try to follow the steps below to do it and check if you can get the table successfully...
1. Disable data type auto detection feature as below screenshot
2. Change the data type of the decimal field with the proper data type
In addition, you can refer the following threads which have the similar problem as yours to get it.
Table.TransformColumnTypes(Table6_Table,{{"Numbers", type any}})
Instead of "type text" as per above syntax use "type any" then problem should be solved
Cannot convert the literal to the expected type 'Edm.Decimal'
Afaik it is still not fixed in PBI.
As a workaround try to filter the results so PBI won't receive too small values in data. Like CycleTimeAvg > 0.05.Best Regards
3 Replies
Hi Anonymous ,
According to the error message, it seems to be a data type convert error. Could you please provide some sample data in the decimal field for the further troubleshooting? And you can try to follow the steps below to do it and check if you can get the table successfully...
1. Disable data type auto detection feature as below screenshot
2. Change the data type of the decimal field with the proper data type
In addition, you can refer the following threads which have the similar problem as yours to get it.
Table.TransformColumnTypes(Table6_Table,{{"Numbers", type any}})
Instead of "type text" as per above syntax use "type any" then problem should be solved
Cannot convert the literal to the expected type 'Edm.Decimal'
Afaik it is still not fixed in PBI.
As a workaround try to filter the results so PBI won't receive too small values in data. Like CycleTimeAvg > 0.05.Best Regards