Forum Discussion
BUG or FEATURE???::DirectLake mode not supported
- 2 years ago
And wouldn't you know it... you have to go traipsing through a labyrinthine thicket of uncommon sense and other assorted illogical UI paths. So here is the solution to connect to lakehouse tables in DirectQuery mode--the long and short of it, you need to figure out where the option to connect to the lakehouse SQL endpoint is, and once you do, select that and badabing-badaboom!, you are in business. Totally ridiculous UI/UX design if you ask me (not to mention that the previous attempts do not generate any visual feedback to let you know what the hell is going on), but there you've it:
- 2 years ago
Just a simple CREATE VIEW where I select a computed col in addition to all the cols from the source table. I'd be curious to learn what's the best approach though, in terms of efficiency and so on. What happens each time a report queries the lakehouse table (in DirectQuery or DirectLake mode)? Is the view recomputed from scratch every single time? Or does Fabric use materialized views like Oracle? The underlying data store being managed by Microsoft, I'd assume they configure it so that it is optimized for READ speed, but who knows, right?
I also heard you actually can WRITE to a lakehouse table, instead of just creating a virtual table, but only if using PySpark in a notebook. Haven't tried yet.DROP VIEW vTABLE_CALC_COL; GO CREATE VIEW vTABLE_CALC_COL AS SELECT *, ([count] /2 ) AS calcol FROM Data_15MThe new calculated col, calcol, then shows up in dataflows and models.
We're definitely using lakehouse, however, I note if I select the Lakehouse link in the Browse menu, it gives me below
Is that what you see?
If, instead, you select the SQL Endpoint for the lakehouse, you'll hopefully also get the Reporting menu
If you are seeing the Reporting menu and there's no option for default semantic model, I'm afraid I have no idea why
Holy Molly this is strange! I definitely do not have 'Reporting' in the ribbon. My top of screen looks like this.. just noticed the Manage semantic model thing is all the way to the right (got a very wide screen and was so focused on the left, didn't see what was going on the right).