Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Refresh error "We cannot convert the value null to type Date"

My pbix was refreshing fine in the service until yesterday.  Today, it fails with the error "We cannot convert the value null to type Date" in the Date table.  I didn't modify anything in my pbix.  I...
Need Help
GilbertQ's avatar
GilbertQ
Super User
7 years ago
Would it be possible to see if what version your Gateway is on?

What does this line do?
#"Convert List to Table" = Table.FromList(Custom, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi GilbertQ,

 

I ended up getting rid of the Date table and just used the date column from my Daily Rates table.  I'm now able to refresh in the service without the error.  But here's to answer your questions.  My gateway version is below. 

 

The line 

 

  • #"Convert List to Table" = Table.FromList(Custom, Splitter.SplitByNothing(), null, null, ExtraValues.Error)

 

is to convert the generated list of dates from the previous line

 

  • = List.Dates(Source, Number.From(CutOff) - Number.From(Source) +1 ,#duration(1,0,0,0))

 

 

Best regards,

 

Ferdinand

Related content