Forum Discussion

cathoms's avatar
cathoms
Responsive Resident
5 years ago
Solved

Error when trying to load to data model

Help! I built a query and it is doing what I want (see last image) but it won't load to the data model. I get the following error message:   Here is the query: let Source = Excel.Workbo...
Need Help
  • cathoms's avatar
    cathoms
    5 years ago

    I hate when this happens but after long hours of frustration and trying to figure out the issue it turns out I had some blank rows buried in the source file. A simple remove blank rows fixed the problem...

amitchandak's avatar
amitchandak
Super User
5 years ago

cathoms , please check this seems wrong 

Custom1 = Table.AddColumn(#"Removed Columns", "CensusDate", each {Number.From([AdmitDate])..Number.From([DischargeDate])}),

try like

Custom1 = Table.AddColumn(#"Removed Columns", "CensusDate", each {Number.From([AdmitDate]), Number.From([DischargeDate])}),

, try to correct the formula 

  • cathoms's avatar
    cathoms
    Responsive Resident
    5 years ago

    I hate when this happens but after long hours of frustration and trying to figure out the issue it turns out I had some blank rows buried in the source file. A simple remove blank rows fixed the problem...