Forum Discussion

simrantuli's avatar
simrantuli
Continued Contributor
5 years ago

Scheduled Refresh Failure

Hi All,   I am facing an issue with scheduled refresh of one of my reports. So, I have a report which has incrementral refresh applied on 2 tables. The report gets refreshed every 3 hours on Power...
Need Help
collinq's avatar
collinq
Super User
5 years ago

Hi simrantuli ,

 

You may have a parameter issue.  If you go back to edit your queries and find the parameter select "Any Value" from the drop down for the "query" or "list of values" option.

 

OR, a data source may have been moved from its location?  One file that is not there anymore?  OR, the data source was temporarily unavailable?

 

OR, it could that you are combining an external data source within the query and you ahve to remove the external data source (https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/).

 

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
simrantuli's avatar
simrantuli
Continued Contributor
5 years ago

Hi collinq ,

 

All the points that you mentioned seem fine in my case.

Could it be query folding issue? "View Native Query" is greyed out for the tables that I am applying incremental refresh on.

 

Best Regards

Simran Tuli

  • simrantuli's avatar
    simrantuli
    Continued Contributor
    5 years ago

    My data source is MS SQL.