Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

PBIRS Scheduled Refresh Error - January 2021

Hi Power BI Report Server Community,

We upgraded to Power BI Report Server January 2021 and everything seemed to work fine. I was able to publish and refresh with the desktop version. I checked reports and they refreshed.
But later, I realised that not all are refreshing successfully. Some are appearing with an error.

SessionID: 10bcf9ee-3a28-4bf1-897e-ac93544e046d
[0] -1055784932: The module named 'Html' has been disabled in this context.. The exception was raised by the IDbCommand interface.
[1] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

 

I removed any reference to HTML webpage retrievals, and I now get this.

 

SessionID: db646af2-2713-40c4-b06c-28889e716a72
[0] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource.
[1] -1055129594: The current operation was cancelled because another operation in the transaction failed.

When I go to the data sources, they are all there and when I click test connection, they are all successful.

 

We are on New Version : 1.10.7698.27886 (January 2021)

Upgrading from Old Version : 1.6.7364.4075 (January 2020)

Is anyone able to assist.

PBIRS
scheduled refresh
  • Anonymous's avatar
    Anonymous
    5 years ago

    I encounter the same issue for 

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

    Jan 2021 version when I upgrade from Oct 2020 version.
    I fix this issue by uninstall Power BI Report Server and drop the ReportServer database and install Jan 2021 again. 

  • blynchdata's avatar
    blynchdata
    5 years ago

    My Scheduled Refreshes were getting a similar error. The SQL Server Service Pack I was on was very outdated. Once we updated that last week to the most recent one, my Scheduled Refreshes now work. We are running SQL Server 2016.

8 Replies

  • blynchdata's avatar
    blynchdata
    Resolver I
    5 years ago

    My Scheduled Refreshes were getting a similar error. The SQL Server Service Pack I was on was very outdated. Once we updated that last week to the most recent one, my Scheduled Refreshes now work. We are running SQL Server 2016.

  • Icey's avatar
    Icey
    Community Support
    5 years ago

    Hi Anonymous ,

     

    For the first error, this is caused by the limitation of Power BI Report Server. Currently, the html module is not available in Power BI Report Server.

     

    Reference: The module named 'Html' has been disabled in this ... - Microsoft Power BI Community

     

     

     

     

     

     
    Microsoft
     
     

     

    ‎11-24-2020 03:15 PM (1867.74 hours)

    The html module is not available in Power Bi Report Server, this prevents refresh o reports that use data directly from html (if by the other hand you use well formatted data from web, such as CSv, xml, json refreshes should work fine). Can you confirm if your refreshes were working in previous releases? In the meantime we are clarifying in documentation exactly which m expressions are supported during refresh:

    https://docs.microsoft.com/en-us/power-bi/report-server/data-sources

     

    Thanks

    gboreki

     

     

     

    Best Regards,

    Icey

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Icey 

      Thank you for your reply.
      I had realised that via my research and removed as stated above but could not get the second part going with the COM error.
      It works on the desktop and the credentials state they are successful in the data source section, but the reports fail to refresh.
      Any idea why?

      • gsprague's avatar
        gsprague
        Microsoft Employee
        5 years ago

        Hi Anonymous - a few things:

        1. What datasource(s) are you using?
        2. Would you be able to turn on verbose logging per Troubleshoot scheduled refresh in Power BI Report Server - Power BI | Microsoft Docs ? We added some verbose logs that can help to uncover why this is happening
        3. If possible remove the existing report from PBIRS, re-upload the report, and re-enter credentials 
          1. Try to refresh, and if it fails, capture the logs from ASEngineManagedRoot at that time.
          2. If you wouldn't mind, feel free to send me the logs with the verbose entries included in a direct message and I can take a look.
  • pdbenbow's avatar
    pdbenbow
    Resolver II
    5 years ago

    I'm getting a similar COM error as well:

     

    [0] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, Datasource ods_prod is not found..

     

    It will also tell me there were no credentials found, even though credentials are stored and validated for all data sources.

     

    All data sources are in their correct place, named correctly, and the accounts we're using have the appropriate permissions with line of sight to the either the database servers or network locations where the files are stored.

     

    PBIRS Version 1.10.7698.27886 (January 2021)

    PBI Desktop Version: 2.88.1382.0 64-bit (January 2021)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I encounter the same issue for 

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

    Jan 2021 version when I upgrade from Oct 2020 version.
    I fix this issue by uninstall Power BI Report Server and drop the ReportServer database and install Jan 2021 again.