Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
carloshs1993
Frequent Visitor

Stuck with incremental refresh with direct query

Hi, 

 

I'm struggling with a table in my report. This table is a fact table that stores data from 01-01-2023 until today. I'd like to retrieve data this way: 

 

- All data from 01-01-2023 until yesterday should be archieved in the model, because it's not going to change.

- Data from today should be refreshed through Direct Query.

 

To do so, I've seen that this option is available in PowerBi: 

 

Captura de pantalla 2023-02-05 113324.png

 

So I've enabled option "Get the latest data with DirectQuery" to achieve my objective, this is: retrieve real-time data with Direct Query. And this works for the current day, but tomorrow (I have checked this) my visualization won't show data for the current day (this is, tomorrow). Am I forgetting anything? Why is my data being retrieved correctly for the current date but, tomorrow, my visualization won't show anything?

 

Is there an option in PowerBI to keep some past data and only get today data through Direct Query ?

 

Thanks for your help.

2 REPLIES 2
ppm1
Solution Sage
Solution Sage

What you've described should work. Your direct query partition should be greater than or equal to today (the RangeStart parameter for that latest partition). How did you set up the filter in your query with RangeStart and RangeEnd?


Pat

Microsoft Employee
YukiK
Impactful Individual
Impactful Individual

I second this. DirectQuery option will be from today/effective day onwards. It's good to check all the settings

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.