Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

GWalb55

Dataset failing refresh after external source table change

Submitted by on ‎09-24-2020 05:57 PM

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

 

 

Status: New
See more ideas labeled with:
5 Comments (5 New)
Comments
Anonymous
Not applicable
‎09-24-2020 10:49 PM

Hi, 

 

We are facing the same issue since yesterday morning.

Our dataset is based on SAP HANA and Excel files. Nothing has changed at the source side nor in the dataset itself. But suddenly we can't refresh the dataset via PBI service, altough it refreshes via Desktop.

 

Anonymous
Not applicable
‎09-25-2020 12:56 AM

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.

Anonymous
Not applicable
‎09-25-2020 12:58 AM

We already have 3 reports with the same issue, some with and some without incremental refresh

dawidk
New Member
‎09-25-2020 01:17 AM

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
Advocate IV
‎09-25-2020 07:46 AM

FWIW, my issues seem to be isolated to datasets using incremental refresh... began sometime early yesterday (24th) morning EST.

Idea Statuses