Creating your first Data Warehouse in Microsoft Fabric 

Suggestion: Please do more Fabric videos with focus on Notebooks and analytics like common enterprise needs around price prediction, demand forecasting etc. This will help us the power bi users learn some data science and learn how to use notebooks as well.

Do you know how many videos out there that I've found that shows me how to set up a data warehouse like this? One. This one. Thank you for this!

Thanks you so much for the wonderful videos. Its really helped me a lot and Today I have cleared my DP-600 exam🎉

Patrick, can you please do some videos on how to take weekly raw data files and save them each week with a date stamp to keep historical records? That would be awesome. Basically same files each week, and append them to create a large system of weekly records

I used SSIS for some years but this is next level 😀

Q: why would we need Fabric when we can use Azure SQL and grab data from there? Any response is appreciated , thanks

This is actually great with DWH. But, after I am seeing this, there is a lot of options here, lot of clicks, and you need to know what you are doing. I was considering to get Fabric in our company, but I think the good thing is to have someone who is doing ETL (SQL programming) with Management Studio and prepare all the stuff. This way from Power BI (Fabric) is okay, but why to complicate when there is no need to it.

You are a hero man

Hey Patrick ! This is great video showing example . I wold like to see more store procedures examples like making scds . Cheers !

thanks! you are the best, nice summary!!

This is great. What I would like to achieve with all these new MS tools is ETL that watches a folder inside OneLake (or SharePoint) and when I add a new flat file (csv) to the folder it parses it and appends parsed rows to OneLake db. Then this data is available in PBI. This would be an amazing tutorial if you could provide one.

Great video, Patrick 🙃 If I look at Datamart, which you demoed last year, I can see common ideas, such as having everything together, but very different way of doing things and different audiences (Datamart for citizen dev and datamesh oriented, Data WareHouse for Data Office and IT). Since datamart are in preview since feb 2022 (2 years ago, waouh!) and have a proximity with Dataware House (Get data, create measure, do SQL queries etc...Do Microsoft intend to give up datamart in favor of Fabric Data Warehouse?

Great video, thanks :)

Great, unfortunately for now Identities columns are missing. Can you do some video on SCD Type 2 Dimensions?

It was all fun and games until I needed premium capacity.

All this what you showed Can we do it also if we are having Microsoft Developer account?

Q: How often do you update the Producers list credits at the end?

thx for the fabric vid

Isn't fabric the next version of Synapse ? Also what are your thoughts on Databricks delta lake tables ? As a seasoned SQL developer, fabric is very familiar , it's T-SQL and GUI !

Hi Good Morning!, I have to convert the existing SQL server stored procedure into fabric environment, In my stored procedures there are CURSOR commands but fabric doesn't support CURSOR commands, in this case how do I proceed, is there any alternative.

I assume Data Warehouse would be better than a lakehouse if you are heavy on TSQL. I am curious though if it would be worth migrating from something like serverless sql pool to a datawarehouse. Serverless can already read csv and parquet files from the azure storage account . What are the advantages?

Q:When you add the new schema it seems like the information_schema is removed. Is this something you do that we don't get to see, or is the informaiton schema automatically removed when you create new schemas or where can they be found?

Curious to know how to deal with encrypted data in Fabric, and how we can decrypt those values in power automate/apps.

Exciting capabilities!

What is the price for this warehouse feature? If I don't need a full-fledged warehouse solution, will it be a cheaper option?

Q: Is any of the configuration scriptable, or do you have to go through the GUI?

Isn't it better to use TRUNCATE instead od DELETE in SQL?

is the data warehouse only available in premium capacity or also as part of PPU or Pro. what would be the advatnage of using this over and above a data warehouse deployed on my local server?

Q: what about using setup of active directory to limit access to data for all of possible users? Is this possible? (Not rls on dataset)

I was able to do this without premium capacity, what are the the needed ”... so we can use some Fabric items” 00:57 ?

Hi, I don't see data activator in my trial version, how to show it my MS fabric Home screen? Thanks.

Hi, thanks for your video, seems that Microsoft is preparing their platform that all DWHs should run in the future in the cloud. So could you show us how to implement a SC2 historization here? thanks

looks a copy of snowflake,, style of creating warehouse

greate video, this will help me with my thesis, i have few questions to ask , i wish i had your email such as i can i tell witch data warehouse model are u using or chosen