Forum Discussion
One Direct Lake (OneLake) table is empty despite data in warehouse
Hi all, I created a direct lake (OneLake, not via SQL endpoint) semantic model that is based on a few warehouse tables. Everything worked fine and the report showed data until yesterday. All tabl...
New data was inserted with a SELECT from a view and there was an error that was introduced in the view. After fixing the view and truncating/inserting new data into the table, Power BI showed data. The other issue was that a MERGE statement was used which isn't supported in fabric. Either one of those two things must have caused the issues. It is now resolved, however.
Hi rohit1991,
it's in delta format
tried removing and adding the fact table. No change
created small table in the warehouse and the data shows in the semantic model.