Forum Discussion
Auto refresh schedule in SAP BW
Hi Anonymous ,
What is the connection mode in Power BI Desktop? Please refer to the following document to see if it helps you.
https://docs.microsoft.com/power-bi/connect-data/refresh-scheduled-refresh
When configuring incremental refresh in Power BI Desktop, you first create two Power Query date/time parameters with the reserved, case-sensitive names RangeStart and RangeEnd. These parameters, defined in the Manage Parameters dialog in Power Query Editor are initially used to filter the data loaded into the Power BI Desktop model table to include only those rows with a date/time within that period. After the model is published to the service, RangeStart and RangeEnd are overridden automatically by the service to query data defined by the refresh period specified in the incremental refresh policy settings.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Actually the there is a single prompt of Date wherein I have to select all the dates required. How to set Start and End date for the same column in such a way that all the dates in between are also retrieved ?
Hi Anonymous ,
It seems you need to separate start and end dates. Please refer to the following document to see if it helps you.
In Incrementally refresh data starting:, specify the refresh period. All rows with dates in this period will be refreshed in the dataset each time a manual or scheduled refresh operation is performed.
Please refer to the following document for more details.
https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure#define-policy