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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
daxman
Helper II
Helper II

Latest data in Lakehouse not showing up in Direct Lake Power BI report

I have a Power BI report that is connected to the default dataset for a Lakehouse. Using Gen2 dataflows, I load more data into the Lakehouse (using the "replace" method in the dataflow).

 

When I open the SQL Endpoint, I can confirm that new data has been brought into the Lakehouse. However, my Power BI report is not seeing the new data. It appears to have cached the previous data that was in the Lakehouse. If I wait until the next day, I will see the data, but my understanding is that with Direct Lake mode, I should be able to see that new data instantly.

Is there something else I should be doing? Or is this a bug with the Lakehouse's built in dataset?

4 REPLIES 4
amcpherson
Frequent Visitor

I am having the same issue as well. SQL endpoint shows correct data but the direct lake mode report does not. Was there a solution for this. I do not see an option to refresh my report either.

ananthkrishna99
Frequent Visitor

Hi @daxman , AFIK, Default dataset doesn't support direct lake mode now, it works based on Direct Query. For Direct Lake mode you have to create a custom dataset and for that also you have to refresh the dataset once Lakehouse tables are loaded with data so that Dataset will point to the Latest parquet files.

Interesting, where have you seen that? From everything I've seen, connecting "live" to the default dataset for a Lakehouse is supposed to leverage Direct Lake mode, and only reverts to Direct Query as a fall back method.

The report performance has been good so far, which leads me to believe it's probably not Direct Query.

There is also no way for me to "refresh" the default Lakehouse dataset.

Same issue with the default dataset... The tables in the lakehouse have been updated but the dataset only shows older data in both Direct Lake (report created in the Service) and Direct Query (report created in desktop)

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Fabric Monthly Update - February 2024

Check out the February 2024 Fabric update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.