March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
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:
have you synced the file on to you local?
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?
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"
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.
have you ever been able to pull it from the lakehouse before? how are you connecting?
Proud to be a Super User!
This is my first attempt at live connection Power BI Desktop to a LakeHouse
Steps I took
This shows me the tables in my LakeHouse. Table structure looks good. Data is blank.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
169 | |
144 | |
90 | |
70 | |
58 |