Adobe Analytics continuous date range for refreshing dashboard

Hi stuckymcstuck ,

The input parameters in the Get Data pop-up are used to limit the amount of data. Date Range is filtered using the report range between the start date and end date that you set. More details can be found in the documentation: Power Query Adobe Analytics connector - Power Query | Microsoft Learn.

To refresh the last 30 days at a time, consider incremental refresh, which extends scheduled refresh operations by providing automatic partition creation and management for semantic model tables that are frequently loaded with new and updated data. Incremental refresh and live data are best suited for structured relational data sources such as SQL databases and Azure Synapse, but are also applicable to other data sources. In all cases, the data source must support the following:

The data source must support some mechanism for filtering data by date.

When configuring incremental refresh and real-time data using Power BI Desktop, or when configuring advanced solutions using the Table Model Scripting Language (TMSL) or the Table Object Model (TOM) through XMLA endpoints, all partitions, whether import partitions or DirectQuery, must query data from a single source.

By using more custom query functions and query logic, incremental refresh can be used with other types of data sources, provided that the filters are based on a single query and can be passed in a single query.

More details can be found in the documentation: Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.