Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Unable to Refresh Data in My Report

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?

"data refresh"
Data Refreshes

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    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.