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 editi...
errors in connection
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.

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

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

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

      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's avatar
        v-janeyg-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        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's avatar
      nsbars_rt
      Icon for Advocate I rankAdvocate 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.