Forum Discussion

Icon for Advocate I rank

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

errors in connection

v-janeyg-msft
5 years ago
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.

Icon for Community Support rank

Community Support

5 years ago

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.

Icon for Advocate I rank

Advocate I

5 years ago

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.

Related content