Scheduled refresh for odbc connection

[nsbars_rt]

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.

[v-janeyg-msft]

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.

[nsbars_rt]

Hi, @v-janeyg-msft 

Unfortunately, it doesn't work so. I've tried. It seems, that enabled enhanced metadata format brokes scheduled refresh for the report on the server and there is no chance to rollback. I'd appreciate other advices. I've done a lot of work and now I have to repeat it once again...

[v-janeyg-msft · Accepted solution]

Hi, @nsbars_rt 

You can try to upgrade to the latest version, it fixed some bugs.

Download Microsoft Power BI Report Server- October 2020 from Official Microsoft Download Center

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.

[nsbars_rt]

Hi @v-janeyg-msft 

Thank you, we can close the issue. We reinstalled Report Server and it was solution. Now scheduled refresh works for enchanced metadata format.

[v-janeyg-msft]

Hi, @nsbars_rt 

I am glad that there are no problems now. Due to the version update, there may indeed be some bugs.

Best Regards

Janey Guo

[nsbars_rt]

Hi @v-janeyg-msft 

We've updated Report Server, now version is 1.9.7675.15620 (October 2020).

Also MySQL driver was updated to 8.0. ODBC connection type.

There is another error for scheduled refresh:

COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource.

I've tried to specify credentials in connection string, but without any results. Test for the datasource successfully passes.

Once again, the error is linked with enchanced metadata format. If I uncheck this option - everything works fine.