Adobe Analytics continuous date range for refreshing dashboard

[stuckymcstuck]

Hello, 

I'm trying to create a dashboard using the adobe analytics connector. I'm able to get the data required for the dashboard, however, can only seem to have a set date range. 

Is there a way to set this end date so it is contunious and will pull through the last 30 days each time the report is refreshed?

Thanks 

[QueryWhiz]

Hi @stuckymcstuck were you able to find a solution? As a workaround, you can connect your Adobe data using an external connector like windsor.ai, which lets you filter the date range before taking the data into Power BI, you can even select which fields you want to export on the tool UI, so once data arrives no Power BI your data is already filtered. In case you wonder,  to make the connection first search for the Adobe connector in the data sources list:

Then, you should enter your Adobe credentials to make the connection. After that, you'll see a preview of your data where you can select the fields you want to see in PBI. 

Finally, you just have to choose PBI as destination and copy and paste the url that will appear there in PBI desktop --> Get Data --Web > --> Paste the link

[v-kaiyue-msft · Accepted solution]

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.