What is Microsoft Fabric Data Warehouse

Microsoft Fabric, an end-to-end Saas cloud-based analytics platform, has many workloads and objects. One of the Objects is called Data Warehouse, or in short, Warehouse. In this article, I'll explain what the Data Warehouse in Microsoft Fabric is and how it works, and I will show you an example of it in action.
Read more from my article here:

[aslakjonhaugen]

Fantastic video Reza! You answered many of my questions in this video! 🙂

[ifernandoubbi]

Hi Reza,
Thanks for this video, it's very interesting.

One question, do you have what tool can I use for the following?
In my job I have created a Power BI dataset with more than 10 billion of rows and I have created partitions with incremental mode.
Sometimes I have to refresh old partitions with XMLA endpoint which works well but is a manual process (running XMLA code from SQL Management Studio).
My question is if exists in the market any tool that I can run automatically Power BI XMLA Endpoint code? like years ago with SQL Agent.

Many thanks!
Fer

[ranjanroy]

Hey Reza, Thanks much, i have seen all your Fabric videos, it is great and very informative as always .
I just wanted to ask,
If someone is using an existing Azure SQL warehouse, can we migrate all the tables to Fabric warehouse by pointing to the existing azure SQL that is being used ?

[wildert]

Is this Synapse DW similar to the dedicated pools with 60 nodes MS currently offers? Some of the Fabric documentation says Fabric Data Warehouse is actually delta lake-based?

[decentmendreams]

Thank you so much. How does Incremental Refresh works here ?

[magibis]

Why copilot is not introducing in Microsoft Fabric Trial? Do you have any idea when they will give for Fabric Trial users?

[dnepr]

Hi Reza, thanks a lot for your time and the video review. As for now, I wonder how cost management is provided for all objects in Fabric?

[BajkeTheSerb]

Still unclear which of those connection shown is the DirectLake? :(

[oscarzapatajr]

Hi Reza,
Could you make a video or blog discussing the difference between a data lakehouse and a data wharehouse?

If the final destination of the data is powerbi and excel reports, does it matter which one I use?

[barttrudeau]

Sorry Reza, I accidentally hit the wrong thumb at first, I didn't intend to give this a thumbs down, it's definitely a thumbs up! I'd give it two thumbs up if I could. Great work, so informative.

[dbsql]

I wish I can figure out how to get data in Microsoft Fabric. It seems like it only works with Microsoft data sources.

[danebelarmino]

Hi Reza, this video is very informative.
Just curious regarding pipeline. If I connect to a database in lakehouse, will changes to the original database reflect to the one in data warehouse or is it just a copy?

[wfprjxl]

Hi Reza,

Thank you for sharing the video. It's really informative.

I've been playing with Lakehouse and Data Warehouse in MS Fabric. I have a question. If i load my data into Lakehouse and use Pipeline to Copy data into Data Waterhouse from the same Lakehouse, would that create a duplicate data or it'll only connect through the metadata?

[dineshs]

How to get IP address for datawarehouse in fabric