Forum Discussion
Auto refresh schedule in SAP BW
Hi, I am creating dashboard/ reports by importing data from SAP Business Warehouse Application Server in Power BI Desktop application.
When importing the data, SAP provides prompts to filter out the data. (attached image)
Here, we select a date range for which data has to be extracted.
But, when this report is published on Power BI Service and set for scheduled refresh, will it be able to extract date of YTD ?
Any suggestions on how to set the date range such that the user can specify the from and YTD when importing data from SAP BW Application Server ?
Appreciate help, in advance. Thanks !
5 Replies
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 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
Hi Anonymous ,
Please refer to the following document to see if it helps you.
https://docs.microsoft.com/power-bi/connect-data/incremental-refresh-overview#create-parameters
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