Building Power BI semantic models with Direct Lake in Microsoft Fabric

Рет қаралды 9,652

Күн бұрын

Download the data engineering notebook used in this video: www.skool.com/microsoft-fabri...
In this video we explore Direct Lake mode in Microsoft Fabric, and how we can use it to create really speedy Power BI reports, even on really large datasets.
We look at what Direct Lake is, the benefits of Direct Lake and how to configure it depending on your requirements.
This video is video FIVE in series helping you navigate the switch from the world of Power BI to the exciting new world of Microsoft Fabric, catch up on the series here: • Power BI to Fabric Tra...
Link to Fabric.guru article on Fallback Behaviour: fabric.guru/controlling-direc...
Link to Microsoft article on Fallback Behaviours: powerbi.microsoft.com/en-us/b...
#powerbi #microsoftfabric #dataanalytics
Timeline:
0:00 Intro
1:18 Exploring the Kaggle dataset
2:54 Default semantic model
4:16 Creating your own semantic model
5:08 What is Direct Lake mode?
7:30 Benefits of Direct Lake mode
7:55 Building a semantic model
9:16 Creating a Power BI report from our model
11:26 Direct Lake Fallback Behaviour
13:30 Semantic model refresh setting
15:12 Fallback behaviour + Semantic Link

Пікірлер: 36

@LearnMicrosoftFabric 3 ай бұрын

Hey everyone, this is video FIVE in our Power BI to Fabric series. You can download the data engineering notebook used in this example here: www.skool.com/microsoft-fabric/classroom/c75b239c?md=939ef9bdae2145389f6d7244c622349f

@kates1736 2 ай бұрын

Great video! Thank you for sharing your knowledge and experience.

@LearnMicrosoftFabric 2 ай бұрын

No worries, thanks for watching!!

@oliveroshea5765 3 ай бұрын

these videos are really good. Haven't watched them all yet, but they are on my to do list! Many thanks!

@LearnMicrosoftFabric 3 ай бұрын

Thanks for watching and thanks for the feedback... there's lots to catch up on!! 😂 And also lots more to come in the future 😊🙌

@hansvetters8026 3 ай бұрын

The series Will is putting together here are indeed very good! I dare to say even the very best on all "getting started with fabric" content out here.

@LearnMicrosoftFabric 3 ай бұрын

@@hansvetters8026Very kind of you to say, thanks Hans! The next one is out on Friday 🙌🙌

@azwarmzafar 2 ай бұрын

This is another great one, continuing my journey of going throguh this series. many thanks. I see you as an infuencer in this domain of introducting MS Fabric on YT soon you will be top voice one.

@LearnMicrosoftFabric 2 ай бұрын

Thanks for watching 🙌🏽

@davidrojas1384 Ай бұрын

Thanks for your videos!!! They are all really useful in my job Just one question, is there a way to create another variables/columns in power query if we use One lake / lake house?

@leankassio671 17 күн бұрын

Thanks!

@LearnMicrosoftFabric 17 күн бұрын

Thanks a lot for your support 😃🙏

@chrish.5494 3 ай бұрын

Hey there, enjoying your Videos on Fabric! In this case I believe it would be important to mention that any user interaction is consuming CU of your Capacity. So depending on the number of users and the interaction direct lake can be quite expensive in number of CU compared to import mode.

@LearnMicrosoftFabric 3 ай бұрын

Hey thanks for the comment! Really good point, thanks for drawing my attention to that. It's not something I've investigated in detail yet (CU usage of Direct Lake), but definitely will in the future!

@ThePerkses 3 ай бұрын

Great videos! Are you able to use a shortcut as a source for a semantic model or do you need to move the data out of a shortcut first? Shortcuts don’t show up as tables when I try to pull them into a new model.

@LearnMicrosoftFabric 3 ай бұрын

Yes, I am able to bring shortcut data in my semantic model Are you creating a new semantic model? (and then click refresh when you get the popup to select datasets to include in the semantic model(

@adatalearner 13 күн бұрын

can one create semantic model based of the tables from external sources such as on-prem database, azure sql or synapse workspaces?

@FatherLizard 3 ай бұрын

Thanks so much for this. Did you make it to Fabcon Will?

@LearnMicrosoftFabric 3 ай бұрын

Glad you enjoyed! I didn’t make it this year, but the photos and announcements looked amazing, maybe next year ☺️ did you go?

@FatherLizard 2 ай бұрын

@@LearnMicrosoftFabric I did - so much of the reason we are getting through the initial steps of our fabric journey is owed to your content. I thank you!! Hope you see you next year!

@MrThuralion 3 ай бұрын

Hey Will, how much have you tried Fabric with a paid capacity versus trial? I run into a lot of snafu when I use my paid capacity where it says I need to upgrade to trial, though it feels like that should be a downgrade! Any similar experiences?

@LearnMicrosoftFabric 3 ай бұрын

Hmm that doesn’t sound right, I would raise a support ticket with Microsoft - haven’t heard of that before. Mostly I’ve been using trial capacities with some paid capacity to test features. Haven’t experienced what you’re describing

@williamstanleyjevons5912 Ай бұрын

Hello really nice video! Do you know if there is a way to transform the data of that semantic model in a power query like method or are we obliged to transform the data upstream ?

@LearnMicrosoftFabric Ай бұрын

Thanks - in Fabric, we have Dataflow Gen2 which is I think what you're asking? Can use Power Query to transform data before Power BI semantic modelling?

@user-ky7yx4gi5j 3 ай бұрын

What persmissions do people need, that want to see the data in the report which is using direct lake?

@LearnMicrosoftFabric 3 ай бұрын

you can read more about how the fabric permissions model works here: learn.microsoft.com/en-us/fabric/security/permission-model

@powerbicoach4209 2 ай бұрын

What is the benefit of Direct Lake on data imported and transformed once a day?

@LearnMicrosoftFabric 2 ай бұрын

If it's only once per day, and your dataset is small enough to use import mode, probably best just to use that 👍 I talk a bit more about choosing between them here kzfaq.info/get/bejne/Z7F7Zrh8vNHHfmw.htmlsi=td0uYkvkgYL-cUt_&t=1186

@MrThuralion 2 ай бұрын

I can't create a semantic model in a Workspace that doesn't have a lakehouse right? And if I have 2 lakehouses in 1 workspace I can't connect to tables from both when creating a semantic model? I'm guessing I should avoid creating architecture based on this, thoughts?

@LearnMicrosoftFabric 2 ай бұрын

On your first question: you can create semantic models from a Lakehouse or a Data Warehouse (KQL databases are a bit different atm), you need at least one. Q2; if you have two lakehouses and you want to use Direct Lake mode, you will need to shortcut the tables you need from one Lakehouse into the other, then build your model from there.