Getting error when trying to load table from azure cost management app with PBI desktop

[roshan_raut]

Hi Guys, I have connected to the azure cost analysis tables through the azure cost management app.
When I try to connect to table like Budget I am able to connect, but when I am trying to connect to Usage details table I am getting this error:

= Source{[Key="usagedetails"]}[Data]

Expression.Error: We cannot convert the value null to type Record. 
  Details: Value= Type=[Type]

 Can you guys help me how to resolve this error?
Thanks in advance... 

[v-yangliu-msft]

Hi  @roshan_raut ,

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

This is the related document, you can view this content:

https://community.powerbi.com/t5/Desktop/how-to-remove-null-values-from-columns-having-record-values...

https://community.powerbi.com/t5/Desktop/We-cannot-convert-the-value-quot-quot-to-type-record-error/...

Best Regards,

Liu Yang

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

[amitchandak]

@roshan_raut , Please log an issue too. Check any known issue before it. I checked similar issues, but seem like no solution for most of those https://community.powerbi.com/t5/Issues/idb-p/Issues

Make sure you are trying this on latest version of power bi