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.
Nope... I checked both my lakehouse view and the SQL analytics view but the ribbon is different from yours. Are you sure you aren't in the warehouse view rather than the lakehouse view?
(Yes, Power BI Service is Power BI in the cloud. I can't bring myself to say Fabric as Fabric encompasses multiple services and not just PBI).
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
- Element1152 years ago
Memorable Member
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).
- Element1152 years ago
Memorable Member
Are you using a Fabric Trail or a paying F SKU?
- Kryt0n2 years ago
Advocate I
We're using Trial
What did clicking the "Manage default model" get for you? Were tables already selected?
- Element1152 years ago
Memorable Member
UsingTrial too. Haven't clicked on it because TBH I'm afraid of something else weird going wrong. I am working on a test project right now and want to finish that before something else blows up. I say this because at the moment, since last Friday, I cannot create any new dataflows, only work on those I had created prior. Crazy, right?!