Greetings Enterprise DNA community,
I’m using an API to extract exchange rates for a report within PBI. The only custom M code that was input was a date parameter used in my source.
Whenever I attempt to refresh the source at the beginning of a new month, it resets the date column to a type “Type”.
“Expression.Error: We cannot convert the value “2018-01-01” to type Record.
Any suggestions on how to avoid this from occurring? Whenever I select “Go to Error”, it reverts back to the step where I converted the data to a table.