Microsoft Fabric Lakehouse

Рет қаралды 16,045

Күн бұрын

Microsoft Fabric is an end-to-end Data and Analytics software-as-a-service cloud offering by Microsoft. One of the important objects of Microsoft Fabric is Lakehouse. In this article and video, you will learn what Microsoft Fabric Lakehouse is and how to create it, load data into it, and read data from it.
Read my article here to learn more:
radacad.com/microsoft-fabric-...

Пікірлер: 51

@ayandapeter1681 23 күн бұрын

Just wanted to say thank you Sir for your insightful videos

@RADACAD 18 күн бұрын

You are very welcome

@hahuyhung5248 Жыл бұрын

Please make a series of MS Fabric, especially for Power BI user 😊 And do you know any pricing table of MS Fabric?

@RADACAD Жыл бұрын

That is on the plan :)

@ricardocontreras Жыл бұрын

Thank you!..i am learning from you!... regards from Ecuador

@RADACAD Жыл бұрын

Cheers

@ZappPSR Жыл бұрын

Thanks Reza. That part of adding the table to a destination (Lakehouse) was the tricky part. Also the "Connect to SQL Endpoint" explanation open new possibilities. PS.: I still have that shirt from RADCAD I won at Montreal/Canada 2018. RLS Question!!

@RADACAD Жыл бұрын

Yes, SQL endpoint is great Oh, yes, I remember that RLS session, great time 😃👊 good to see you here

@masoudpesaran9721 Жыл бұрын

Very informative, & Gr8 Explanation! Besiar Ziba bood.

@RADACAD Жыл бұрын

Thanks for liking

@mohamedabdulatty7997 Жыл бұрын

Thank you so much ❤

@CH-js4lg Жыл бұрын

This video is awesome. I spent tons of times in searching for the "right" and "clear" information about fabric and this is genuine. Thank you for a great work. One of my questions is, in the first video, you talked about "direct lake" mode. If we can use "direct lake" mode, then why do we still need Lakehouse? I know this a quite weird question. But I am still confused with the "future concept" of fabric. What is the difference between "OneLake" and "Lakehouse" ?

@RADACAD Жыл бұрын

Glad you liked it OneLake is the storage engine for Fabric. Lakehouse, however is one of the objects that you can create in Fabric, the Lakehouse can keep data in structured or unstructured format, and it will save it in the OneLake. So no matter if you use Lakehouse or Warehouse, you still use Onelake, because that is the storage engine. Power BI then provide connection to it using Direct Lake, which is a direct connection to the OneLake. If you check our few of our other videos about Fabric some of these concepts would be explained more in there.

@CH-js4lg Жыл бұрын

@RADACAD Thanks. It helps me to better understand fabric ! I will watch the others as well.

@dumisaralane Жыл бұрын

Awesome video, thank you.

@RADACAD Жыл бұрын

Glad you liked it!

@FrankyLeeuwerck Жыл бұрын

Thx! Interesting demo

@RADACAD 11 ай бұрын

Glad you liked it!

@Dipsvloggermany2021 Жыл бұрын

could you please make an end to end project video on fabric then we would be able to connect the dots and understand the whole process.

@RADACAD Жыл бұрын

an end-to-end project might come in different paths; sometimes it might uses lakehouse, etl, and Power BI. Sometimes it might uses ETL, Data Warehouse, and then Power BI and Machine Learning. I'll come up with scenarios hopefully in some videos to cover some of those.

@julianatorressanchez5250 7 ай бұрын

Great. Please explain what is the advantage to connect to a dataflow created in a lake house, and to a dataflow, because I understand that we have the two options when creating a lake house. I appreciate your help. Is not clear for my, because I can create A data flow in power bi service too. Thank you so much👍

@rbrohitbisht 11 ай бұрын

Really informative. Can you please confirm if the LakeHouse can be used in place of Kusto? If we take about a very huge volume of data and queries?

@RodrigoBocanegraCruz Жыл бұрын

Thanks for sharing! Interesting the way you can also create a semantic model in the data lakehouse. Can we create multiple models in the same lakehouse? I'll look forward to your videos showing how that links to data marts.

@RADACAD Жыл бұрын

Thanks Yes, you can build more datasets with importing data from Lakehouse. I'll work on the datamart vs lakehouse video sometimes soon.

@narayanjena4259 Жыл бұрын

Thank You

@RADACAD Жыл бұрын

You're welcome

@damiancz2339 Жыл бұрын

for dataset modify, what if i enable option on workspace to modify dataset online ( which is new feature from april i believe) this would give option to modify "power bi item" dataset

@sanketmane9697 Жыл бұрын

Can we load multiple tables in the lakehouse in a single go

@gates1978 Жыл бұрын

Thank you Reza for the videos. Could you start a playlist to go over data lake and warehouse by details , and little bit slowly to follow Microsoft updates. I feel MS are going fast.

@RADACAD Жыл бұрын

Sure, we'll have a play list for Fabric. and there will be videos for comparing Lakehouse and Warehouse and Datamart etc.

@hmvideo2244 Жыл бұрын

Thank you Reza, for the great video. Where can I download AdventureWorksDW Excel file? Could you please share the link?

@ankitamalhotra5761 Жыл бұрын

Thanks for the introduction, Could you please let us know what is going to change for a power BI developer, most of the editing experience would move to cloud?

@RADACAD Жыл бұрын

I guess Power BI web editing experience at some point will be strong enough to do everything in the web. However, the Desktop would still exists I imagine as it is faster to do things there.

@yordanosadigo Жыл бұрын

Thank you for the great introduction. So is Power BI Desktop, Datawarehouses will be replaced by this feature ?

@RADACAD Жыл бұрын

I don't think so, Data warehouse is still different than the Lakehouse, I might do another video about that subject later. But most of the Power BI Desktop functionality is coming to web now, Which would make Power BI editing experience anywhere, even from Mac devices

@gates1978 Жыл бұрын

@@RADACAD that's amazing . I like the features .

@mohammedmanna3488 Жыл бұрын

Thank you Rada I Tried to connect lakehouse with my SQL Server in my local machin by adding the server name and database name and simpl select some filed but it give me error by the way the steps i did with power query it is working if there is any additional steps for lakehouse Thanks in advance

@mohammedmanna3488 Жыл бұрын

@user-mc3eq8fu9l Жыл бұрын

Could you pls tell me will the SQLend point file be created or not for the semi-structured and unstructured data if we load into DataLake

@RADACAD Жыл бұрын

SQL endpoint won't make sense for unstructured data, it only makes sense when you are querying a data table.

@mohamedabdulatty7997 Жыл бұрын

After published I didn't find dataset only SQL endpoint and lake house plus no refresh icon

@RADACAD Жыл бұрын

Did you load the data into the Lakehouse?

@simonloughnane6683 Жыл бұрын

Thank you Reza, that is very helpful. When I tried Fabric I was confused by the different objects that were created in the Workspace. It does seem odd to me that you can write new DAX measures and structure your data in the SQL Endpoint rather than in the Power BI Dataset - is there a reason for that?

@RADACAD Жыл бұрын

You're welcome You are still doing that in the Power BI Dataset, however, the entry point of that seems to be from SQL Endpoint link. I imagine we might have an entry point from the dataset itself in the future too.

@mueezurrehman9266 11 ай бұрын

What is the difference between Lakehouse and One Lake?

@RADACAD 11 ай бұрын

OneLake is the storage. Lakehouse is a logical object, which stores both structured and unstructured files, but the storage that the Lakehouse uses is OneLake.

@hesammohammadi6969 Жыл бұрын

Hello Reza, Thank you so much. I cannot get the AdventureWorksDW_2019 excel file. Please help me 🙂

@RADACAD Жыл бұрын

Sure. You can get it from here: radacad.com/files/AdventureWorksDW2012.xlsx

@hesammohammadi6969 Жыл бұрын

@@RADACAD Thanks a lot🙏🙏

@RowlandGosling Жыл бұрын

I hope Microsoft Fabric isn't mandatory to use Power BI, Synapse or Azure Data Lake. Some customers can't or won't do that. For example, some customers use an ADLS2 storage account for DEV, another for QA/UAT and another for PROD. One of the promises of OneLake is there is only one account. Also, the data is auto-tagged. How does one override a bad/stupid tag? It will happen. I'm hoping I'm wrong on these, but I have concerns. Also, if the entry point for Power BI is through this channel only - we'll see adoption drop - not grow.

@RADACAD Жыл бұрын

No Power BI will go as is. You don't need a Fabric license or pathway to use it. As you said, for some businesses, Power BI itself is enough. But if you have Fabric, you can do more