We have had issues refreshing a dataset after a column was added to an azure based SQL datasource environment table. This dataset is able to successfully perform desktop refreshes with no issue in any table, but when published and refreshed in PBI service it results in failures. The dataset does have incremental refresh implemented, credentials have been reset but also did not change since the issue occurred, nothing else changed within the dataset other than the source table column addition.
Error received in PBI web service:
| Data source error: | [Unable to combine data] Section1/... 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. |
| Time: | 2020-09-24 23:55:20Z |
5 Comments
Hi,
I have exactly same issue, for the fix i have turned off incremental refresh and now refresh seems to be working, in long term this is not a solution due to data amount.
Not sure what king of update Microsoft has made recently but i have multiple report failing due to inremental refresh. No change in Data set it just started to fail from 24.09.2020.
Same problem here. Reports with incremental refresh and more than two data source does not work.
I have reports with two data sources and they are just working fine.
- musicbydannyd
Advocate IV
FWIW, my issues seem to be isolated to datasets using incremental refresh... began sometime early yesterday (24th) morning EST.
