Forum Discussion
Incremental refresh combined table
Good day, everyone,
Hi, I have two queries that have an incremental refresh setup from a SharePoint folder where the queries are updated with each new day's data, and these work fine. I have then combined these two queries into a third one and set up an incremental refresh on this third one as well, but the resultant table never updates past the end date of the initial parameter date that was used for the range end. All the incremental refresh settings are the same and use the same parameters.
Can any help me identify where the issue lies?
Thanks
Hello richardwg,
Can you please try the following to troubleshoot:
- Ensure that the incremental refresh policy is properly set up for the combined query. Review the RangeStart and RangeEnd parameters in your incremental refresh policy.
- Check the M code for both the individual queries and the combined query. Ensure there are no steps that could inadvertently filter out new data. (Look for any hardcoded dates or filters)
- Confirm that the SharePoint folder data source is correctly set up and that Power BI can access the latest files. If there are any permissions or connectivity issues with SharePoint, it could affect the refresh.
- Double-check how the parameters are used in the queries. The parameters should dynamically control the data range for the incremental load. (Ensure that the parameters are not being used in a way that limits the data to the initial load period)
Should you require any questions or further assistance, please do not hesitate to reach out to me.
1 Reply
Hello richardwg,
Can you please try the following to troubleshoot:
- Ensure that the incremental refresh policy is properly set up for the combined query. Review the RangeStart and RangeEnd parameters in your incremental refresh policy.
- Check the M code for both the individual queries and the combined query. Ensure there are no steps that could inadvertently filter out new data. (Look for any hardcoded dates or filters)
- Confirm that the SharePoint folder data source is correctly set up and that Power BI can access the latest files. If there are any permissions or connectivity issues with SharePoint, it could affect the refresh.
- Double-check how the parameters are used in the queries. The parameters should dynamically control the data range for the incremental load. (Ensure that the parameters are not being used in a way that limits the data to the initial load period)
Should you require any questions or further assistance, please do not hesitate to reach out to me.