Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
8 | |
3 | |
2 | |
2 |
User | Count |
---|---|
15 | |
11 | |
5 | |
4 | |
2 |