Forum Discussion

sdhzhsz's avatar
sdhzhsz
Regular Visitor
5 years ago

Updated to the latest version, but still not working

Hi,

I have installed the latest version : 

Desktop : 2.86.1321.0 64-bit

ReportServer : 1.9.7675.15620 

Datasource：Oracle

 

 在 Microsoft.AnalysisServices.Tabular.Model.SaveChangesImpl(SaveOptions options)
   在 Microsoft.PowerBI.ReportServer.AsServer.TOMWrapper.RefreshModel(Database database)
   在 Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.RefreshDatabase(String databaseName, IEnumerable`1 dataSources, IEnumerable`1 parameters, String clientSessionId)
   在 Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.RefreshDatabase(AsDatabaseInfo asDatabaseInfo)
   在 Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass34_0.<ExecuteActionWithLogging>b__0()
   在 Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__33`1.MoveNext()
2021-01-20 15:24:33.5686|ERROR|178|Error Processing Data Model Refresh: SessionId: f39adfc4-62d6-4d61-8eab-8ee5b865773f, Status: Error Failed Data Refresh, Exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: 'COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource.
COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource.
COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource.
COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource.
COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource.
The current operation was cancelled because another operation in the transaction failed.

 

 I really need your help，Thanks

COM Error

7 Replies

  • FarhanAhmed's avatar
    FarhanAhmed
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Have you checked Users' credentials under Datasource Tab on of report publish on PBIRS?

     

    Is refresh working fine from Power BI Desktop optimized for Report Server?

    • sdhzhsz's avatar
      sdhzhsz
      Regular Visitor
      5 years ago

      Yes, It's OK.

      It can also be successfully refreshed in power bi desktop.

       

      by the way

      the old file , is working fine on reportserver. but when i turn on the preview feature,edit and save,upload to the RS,the same problem arises

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi sdhzhsz ,

     

    Option 1:

     

    In PBI Desktop Oct 2020, open every report query and data source

    Change the connection information to all lowercase

    Save the report and republish to PBIRS

     

    Option 2:

     

    Before the PBIX file is upgraded to the new format in the October 2020 version of PBI Desktop (Optimized for PBIRS), a backup copy is saved in the AppData folder:

     

    C:\Users\<user>\AppData\Local\Microsoft\Power BI Desktop SSRS\TempSaves\Backups

     

    Open PBI Desktop and turn off the Enhanced Metadata option. Go to File -> Options and settings -> Options -> Global-Preview features -> then uncheck the option:

    Restart Power BI Desktop

    Reopen the backup PBIX file

    You should be able to use this version of the report and publish it to the PBIRS server. It is the v1 model and the same format as in May 2020 PBIRS.

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

     

    Best Regards,

    Dedmon Dai

     

     

    • sdhzhsz's avatar
      sdhzhsz
      Regular Visitor
      5 years ago

      I changed the datasource and it still doesn't work. The file in the backup folder is not the latest version , and I have made several updates. May I ask when you can launch an update to fix this problem, eagerly looking forward to

      thank you very much