Hi,
I have three tables for my PowerBI Dashboard:
- JobAid - SQL Server table that contains the current weeks data
- JobAid Archive- SQL Server table that contains all past fiscal weeks data
- Job Aid Append - A table that appends the "JobAid" table and "JobAid Archive" table
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?
Have you checked if you have difference of data type between the JobAid and JobAid Archive for the same column ?
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Have you checked if you have difference of data type between the JobAid and JobAid Archive for the same column ?
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
