Forum Discussion

cassidy's avatar
cassidy
Power Participant
3 years ago

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.


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

 

 

12 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion

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

    • cassidy's avatar
      cassidy
      Power Participant

      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.

       

       

       

      • Emanshu's avatar
        Emanshu
        Advocate I

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

    • cassidy's avatar
      cassidy
      Power Participant

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

    • cassidy's avatar
      cassidy
      Power Participant

      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?