Direct query on Fabric not showing all data

[m_cherriman]

Hi,

I've created a data model in a Frabric Lakehouse and I've created a Power BI report on top of this.  In my transactions table the latest date is 6th January 2024, but when I query this in Power BI the latest date is 18th November 2023.

SQL Endpoint

Power BI

Can anyone explain why the data in Power BI is not refreshing or querying the whole table?  I have a similar issue with another table, but is much smaller so I don't believe it is a sizing issue.  The second table also ends on the 18th November.

I am useing the Fabric trial to build out a POC, but can't access all of the data I require.

[GilbertQ]

Hi @m_cherriman 

Did you create the Power BI report using direct lake or are you using the import mode? If you're using the import mode, you would need to schedule a refresh of the data to bring the new data into the Power BI data set.