topic Scheduled refresh for odbc connection in Report Server

Scheduled refresh for odbc connection

nsbars_rt — Wed, 30 Dec 2020 09:21:52 GMT

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.

Re: Scheduled refresh for odbc connection

v-janeyg-msft — Fri, 01 Jan 2021 06:23:46 GMT

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.

Re: Scheduled refresh for odbc connection

nsbars_rt — Sat, 09 Jan 2021 12:37:02 GMT

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...

Re: Scheduled refresh for odbc connection

v-janeyg-msft — Mon, 11 Jan 2021 08:03:40 GMT

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.

Re: Scheduled refresh for odbc connection

nsbars_rt — Thu, 14 Jan 2021 06:56:43 GMT

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.

Re: Scheduled refresh for odbc connection

nsbars_rt — Mon, 18 Jan 2021 13:44:17 GMT

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.

Re: Scheduled refresh for odbc connection

v-janeyg-msft — Tue, 19 Jan 2021 01:36:55 GMT

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