Forum Discussion
Unknown Error when trying to edit changes to Datamart
Hi,
I was editing the dataflows, and my datamart fine with no issues when all of a sudden, i get this error that doesn't tell anyone much.
It occurs when trying to save new changes to my datamart. I can see the changes fine when I go to "transform data", all my columns are there with no errors. When I save them and the checks happen I get a fail at "Loading Data".
Through my searching, I can see that a lot of similar issues resolved themselves but I was wondering if anyone had any leads as to how I can debug this?
I would hate to write this off as "preview doing preview things" giving how useful I'm finding this product.
After many hours of tracing back steps I've found what I suspect to be the issue.
For one calculated column:
"each if Number.IsNaN([SuccessfulCount] / [TotalShifts] * 100) then 0 else ([SuccessfulCount] / [TotalShifts] * 100), Int64.Type)"
The issue was NaNs. For whatever reason, they will sneak by all the checks but error when loading in the data.
I got around this by converting the column to text type then using the replace tool, then converting back to whole number.
1 Reply
After many hours of tracing back steps I've found what I suspect to be the issue.
For one calculated column:
"each if Number.IsNaN([SuccessfulCount] / [TotalShifts] * 100) then 0 else ([SuccessfulCount] / [TotalShifts] * 100), Int64.Type)"
The issue was NaNs. For whatever reason, they will sneak by all the checks but error when loading in the data.
I got around this by converting the column to text type then using the replace tool, then converting back to whole number.