Auto refresh schedule in SAP BW

[mitapate]

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 !

[Anonymous]

Hi @mitapate ,

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

[mitapate]

Hi can you please share an example of how to create these parameters and then apply on loaded data in Power BI Desktop. Also, will we then be able to change in Power BI Service ?

[Anonymous]

Hi @mitapate ,

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.

[mitapate]

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 ?

[Anonymous]

Hi @mitapate ,

It seems you need to separate start and end dates. Please refer to the following document to see if it helps you.

https://stackoverflow.com/questions/65291204/how-to-create-start-and-end-date-columns-from-date-colu...

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