Forum Discussion
Memorable MemberPower BI Report Server September 2022 Issues
Memorable MemberAfter 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?
yes, 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.
- josef78
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?
- josef78
In my case, refresh is failing if source contains any column with text string with length greater then 512 characters. Currently, my only solution is trunc text string under 512 char.
