Forum Discussion
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/Source references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.. The exception was raised by the IDbCommand interface.
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. I specify that from local PCs the reports refresh without problems, the data refresh does not work only from the Report Server.
Can anyone help me?
Thank you!
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.
2 Replies
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.