User Profile
StefaniaVargas
New Member
Joined 1 year ago
User Widgets
Contributions
ODBC error: numeric overflow or string truncation. Expected length 31, actual 63
Good day, Im having a error in power Query after the IT department connected Power BI to ODBC database. The error is the following: ODBC error numeric overflow or string truncation expected lenght 31, actual 63 details: Datasourcekind= Odbc DatasourcePath=dsn= VARIO OdbcErrors =[Table] I've tried to solve the truncation error from power query editor updating the M Code as follow but the problem persist let Quelle = Odbc.DataSource("dsn=VARIO", [HierarchicalNavigation=true]), REB_Table = Quelle{[Name="REB",Kind="Table"]}[Data], // Get the list of text columns TextColumns = List.Select( Table.ColumnNames(REB_Table), each Value.Type(Table.Column(REB_Table, _)) = type text ), // Truncate only text columns to 31 characters TruncatedTable = Table.TransformColumns( REB_Table, List.Transform( TextColumns, each {_, each Text.Start(_, 31), type text} ) ) in TruncatedTable Would appreciated any idea of what the solution might be, thank you in advanced. Many Thanks Kind RegardsSolved2.1KViews0likes5Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.