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.
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.