Forum Discussion
Azure Analytics to SQL -- issue with datetime data type
I was running a PowerBI against and Azure Workspace log but due to the amount of data that I had to fetch across multiple tenants I decided to import it into a local SQL server. I was able to upd...
And I just verified my datatypes, datetime is what the Azure workspace logs show for datetime.
I also matched strings to nvarchar and int to int so everything should be matching technically.
samw5 Has the problem been solved?
If not, after the first source step, is there a Changed Type step which is automatically generated by Query Editor? Does this step has any error? If there is any column having an error in this step, remove the error column's change-type M code in the step, then add a separate step below it to try to change the data type of this column to see whether it is able to be changed correctly.