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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
cassidy
Power Participant
Power Participant

OneLake live connection missing data

In attempts to connect live to a LakeHouse in Desktop, only 1 of my 5 tables shows data despite data showing in full in Service.

 

  • The 1 table that did work is the smallest of the 5, but the example below is a only a few hundred thousand rows

 

Displaying data values for example table in created LakeHouse in Service.  I can Query it and return any result I want.

cassidy_0-1687469232598.png
After Get Data > OneLake > choose my LakeHouse, the same table has no values at all for any column:

cassidy_1-1687469368148.png

 

 

12 REPLIES 12
vanessafvg
Super User
Super User

have you synced the file on to you local?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




@vanessafvg Power BI Desktop live connected to my LakeHouse is now showing data after not checking over the weekend.

 

Is there a known time lag between data being added to the LakeHouse and it being available via Live Connection in Power BI Desktop?

I am having the same issues. Any update about @vanessafvg 

It has been so long now, but I looked back at my Microsoft Tickets and believe this was the solution. 
In your semantic model, turn on " Keep your Direct Lake data up to date"

Emanshu_0-1720038036013.png

Again, this was so long ago when Fabric was still pretty new and it could of just also been fixed on it's own naturally. As I have had that happen with other issues. 

 

Where I find this option? It's in powerbi desktop or fabric interface? 

 

In the Fabric Service > Semantic Model > Settings 

Can you please expand on or provide documenation?  I've not read/heard about that step so far.

vanessafvg
Super User
Super User

 have you ever been able to pull it from the lakehouse before?  how are you connecting?  





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




This is my first attempt at live connection Power BI Desktop to a LakeHouse

 

Steps I took

  1. Create LakeHouse
  2. Import Data
  3. Open Power BI Desktop
  4. OneLake data hub > LakeHouse
  5. Select LakeHouse > Connect

 

This shows me the tables in my LakeHouse.  Table structure looks good.  Data is blank.

 

cassidy_1-1687473681291.png

 

 

I am having the same issues. Only on certain tables, that are no diffrent then the others. 

any update on this?  I have the same issue, i can query in Power BI service and see data but using the lakehouse connector in Power BI Desktop I get no data?

I am having the same issues. 

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.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.