Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Refresh failing (Combine Data)

Hi everyone,   Hi everyone, currently in my company we have PowerBI report server (May 2021). For some reports I get the error below:   [Unable to combine data] Section1/SOI_REVERSAL/S...
"Server"
  • Icey's avatar
    Icey
    5 years ago

    Hi Anonymous ,

     

     

    The data sources we use in these reports are:

    Database1:  xxx.x.xxx.xx;[database name]

    Database2: [server name];[database name]

    Sharepoint: https://xxxxxxxxxxx/xx/xxx

     

     

    SQL Server database tables on Azure and tables from an enterprise SharePoint site.

     

    Data source of SharePoint Online is not supported to refresh in Power BI Report Server. This is the cause of the issue.

     

    List of supported data sources

    Data source Cached data Scheduled refresh Live/DirectQuery
    SharePoint Folder (on-premises) Yes Yes No
    SharePoint List (on-premises) Yes Yes No
    SharePoint Online List Yes No No

     

    Reference: Power BI report data sources in Power BI Report Server - Power BI | Microsoft Docs

     

     

    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, it seems that the real problem inside the report is the following:

 

 

If we delete that piece of code (in the red rectangle), then in the report server, the report now refreashed correctly.

Can you help me with this reason?

Thank you