Power Bi show error when refreshing data from web

[Aymen_Soussi]

Hello I'm having an issue with Power BI when refreshing data from a web source after making some changes in the source data, the error that is shows is  sometimes "We cannot convert the value null to type List" and in other times it shows the error "(500): Internal Server Error". I checked if the data that the source is given and it haven't null values.  After multiple times trying to refresh it may succeed to get the data but it transform string columns to null value.

Please if any one have faced this error and got a solution for it let me know. 

[Anonymous]

Hi @Aymen_Soussi ,

Can you provide a screenshot of the error? 

The error message show that it can't convert null value, perhaps you can try to replace these null value to a default value before your operation.

Best Regards,

Stephen Tao

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