Hi, I have three tables for my PowerBI Dashboard:
All thes tables are in the Import Storage Mode. There are no data transformations in any of these tables.
Today when I refresh the table I am receiving an error. JobAid Append: OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Error converting data type nvarchar to float.
Any ideas on how to fix this error?
Go to Solution.
Have you checked if you have difference of data type between the JobAid and JobAid Archive for the same column ?
Proud to be a Super User!
View solution in original post
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.