Forum Discussion
Helper IIOLE DB or ODBC error
Thank you for your assistance, eventually I managed to find the stupid mistake myself and that was that in a union I was doing, there was 1 singular column that switched with the one below it in the create function.
Helper IIlet
Source = Sql.Database("ssynapseworkspace-ondemand.sql.azuresynapse.net", "DWH"),
dbo_fact_Melding = Source{[Schema="dbo",Item="fact_Melding"]}[Data],
#"Removed Columns" = Table.RemoveColumns(dbo_fact_Melding,{"MeldingGroepId", "Afspraken"})
in
#"Removed Columns"
That is the advanced query editor for one of the tables, all the others are exactly the same only most dont have removed columns.
Helper IIAnother error I am getting on a different column that I removed to see if it was just that issue is the following:
<ccon>DataSource.Error: Microsoft SQL: Conversion failed when converting the nvarchar value 'Controle' to data type int.
I tried to find it but it should never convert it to a INT, as the data type for that column is also just text.