I am getting this error while importing a dataset approximately 1.5 million rows from mongodb to powerbi through sql connector. I have used the same connection of other tasks, so the connection is good. I have filtered the rows to approximately 25000 rows. However, when I import my data into Power BI, I get this error:
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [Expression.Error] Data source error occurred. SQLSTATE: 22003 NativeError: 0 Error message: ODBC: ERROR [22003] [MongoDB][API] integral data "3741325568" was truncated due to overflow. '.
Furthermore, while loading into power bi or even further data processing. The power query seems to query on the whole dataset even after row filter.
Can anyone help?