Unable to Refresh Data in My Report

[avsr]

Unable to Refresh Data in My Report

Hello everyone,

I’ve been working on a dashboard for a while (I’m a beginner) and I can’t refresh the data incrementally. To start, here is a description of my report:

• SQL database
• IMPORT mode
• RangeStart and RangeEnd parameters set to 01/01/2024 and 31/12/2024 (loading disabled)
• Incremental refresh defined on the tables to be updated (last 12 months for archiving and 3 days for refresh)
• Gateways configured in the semantic model on Power BI online
• Automatic refresh scheduled at 1 AM every day in the semantic model on Power BI online

The problem is that I inserted a date slicer that I synchronized across all pages so that when I filter at the beginning, the filter remains.

However, it doesn’t refresh. So I copied my report and made some modifications. When I enable incremental refresh in Power BI Desktop, I no longer see the parameters in Power BI online; it tells me that no parameters are defined.

Can someone please help me?

[Anonymous]

Hi @avsr ,

Scroll down and start from Query Folding section.

If a filter is specified in a query step after the initial source query, the query fold must combine the initial query step with a step that references the RangeStart and RangeEnd parameters.

Below is the official link will help you:

Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

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