Forum Discussion

jpmakako's avatar
jpmakako
Frequent Visitor
2 years ago

Im getting this error with no null values. {We cannot convert the value null to type List}

Hi, Ive checked for all columns and I have no null values in any record. Still, while loading into Power Bi Im no being able to load the table. Any ideas?   McDATAMART_Proyeccion_Datos Failed to...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

I don't see the change

each Excel.Workbook( Web.Contents([Direccion Flujo de Caja en Sharepoint])){[Name=[Entregas Manual]]}[Data]),
jpmakako's avatar
jpmakako
Frequent Visitor
2 years ago
_McAddTableFechas = Table.AddColumn( McCorrectEntregas, "Tabla Fecha",each Excel.Workbook( Web.Contents([Direccion Flujo de Caja en Sharepoint])){[Name=[Tabla Fechas]]}[Data]),
//_McAddTableFechas = Table.AddColumn( McCorrectEntregas, "Tabla Fecha",each [Tabla Consulta]{[Name=[Tabla Fechas]]}[Data]),

If i run it this way, is works, If i comment the above statement and uncomment the lower one power query shows no errors but power bi wont load it. I hope that clarifies the code.