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.