Forum Discussion
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
- vanessafvgCommunity Champion
have you ever been able to pull it from the lakehouse before? how are you connecting?
- cassidyPower Participant
This is my first attempt at live connection Power BI Desktop to a LakeHouse
Steps I took
- Create LakeHouse
- Import Data
- Open Power BI Desktop
- OneLake data hub > LakeHouse
- Select LakeHouse > Connect
This shows me the tables in my LakeHouse. Table structure looks good. Data is blank.
- EmanshuAdvocate I
I am having the same issues. Only on certain tables, that are no diffrent then the others.
- vanessafvgCommunity Champion
have you synced the file on to you local?
- cassidyPower Participant
Can you please expand on or provide documenation? I've not read/heard about that step so far.
- cassidyPower 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?
- antoniofariasFrequent Visitor
I am having the same issues. Any update about vanessafvg