Forum Discussion

m_cherriman's avatar
m_cherriman
Icon for Advocate I rankAdvocate I
2 years ago

Direct query on Fabric not showing all data

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.

 

Need Help

1 Reply

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    2 years ago

    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.