Forum Discussion
Power BI Report Server September 2022 Issues
After upgrading to the September 2022 version, many datasource refreshes started to fail, with a similar error:
"Error: ODBC: SUCCESS_WITH_INFO [01004] Fetched item was truncated." (if PostgreSQL ODBC source)
or "Error: ODBC: SUCCESS_WITH_INFO [01004] String data, right truncated." (if Netezza ODBC source).
Before the upgrade, these refreshes were running fine. I'm still looking for the cause. Does anyone have similar problems?
We have the same problem after upgrading to September 2022 version.
The same error message, we are using PostreSQL and Exasol ODBC sourceyes, I met the same problem yesterday, this is a new published report in PBI Report server and there is no issues when refreshed in PBI desktop.
More and more developers from my company reported this issue in Sep22 release.
It's looks like bug.
In case when ODBC connection returning status "SUCCESS_WITH_INFO", which means successful finish with some warning message, then Power BI Report Server wrongly interpret this as failure (from Power BI Desktop it is interpreted well).
We have the same problem at my company. Refreshing with Power Bi Desktop is fine, Report Server also returns "SUCCESS_WITH_INFO [01004] Fetched item was truncated.."
Is there a solution yet or is a downgrade to the January/May 2022 version the only option?
Yes, we encountered the same problem. We are using Denodo ODBC data source.
Anyone has a solution?
