errors in connection
1 Topic
Scheduled refresh for odbc connection
Hello October update broke my odbc scheduled refresh. We use 1.9.7627.11028 version of report server. Driver version: MySQL ODBC 5.3 Unicode Driver. I used standard PBI Desktop version (not RS edition) for reports creation. After october 2020 Report Server update, I got an error in scheduled refresh history: Data source error: Login failed for data source ‘Unknown’. Information in details: [0] -1055784932: ODBC: ERROR [HY000] [MySQL][ODBC 5.3(w) Driver]Access denied for user '獮㊼戴ؼ졶㍢㶝饆⣆刮'@'myserver' (using password: YES) ERROR [HY000] [MySQL][ODBC 5.3(w) Driver]Access denied for user '獮㊼戴ؼ졶㍢㶝饆⣆刮'@'myserver' (using password: YES). The exception was raised by the IDbCommand interface. If I create new report in PBI Desktop RS edition, uncheck “Store datasets using enhanced metadata format”, then scheduled refresh works fine. But the question is: 1) How I can restore scheduled refresh for my existing reports (without recreating them)? 2) If I should recreate existing reports (this is a pain) with unchecked “Store datasets using enhanced metadata format” - this is preview feature. And when it moves to GA - my refresh will break once again.Solved4.1KViews0likes6Comments