Forum Discussion

nsbars_rt's avatar
nsbars_rt
Icon for Advocate I rankAdvocate I
5 years ago
Solved

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.

errors in connection

6 Replies

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, nsbars_rt 

     

    It’s my pleasure to answer for you.

    According to your description,I think you can open the report created in PBI desktop in RS desktop, then uncheck “Store datasets using enhanced metadata format” and re-publish to PBI report server, maybe it will solve the problem.

    Like this:

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.