Forum Discussion
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...
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...
That allows me to load the data, but then I lose the information I need. CensusDate just becomes two rows for each HAR - the AdmitDate and DischargeDate. I want a row for each date from Admit to Discharge so that I can get a census/distinct count of HARs by date.
Unless there is some way from each set of rows to count HARs for the dates inbetween...
Also, I checked and I don't have any Null values in the AdmitDate or DischargeDate columns. There are a few in the MRN but even removing that column doesn't help.