Microsoft Fabric: Various Components| Microsoft Fabric Create Workspace, Lakehouse, Warehouse

[@dilipinamdar5523]

Thank you🙏

[@AmitChandak]

You’re welcome 😊 Hope you will like full series Mastering Microsoft Fabric 50+ Videos: kzbin.info/www/bejne/pl7ZYXxriJKsmNU

[@mohammadaamirkhan7830]

Thank you Sir for your new good video. I am going to enhancing my skill by learning from this series.

[@AmitChandak]

Thanks 🙏

[@shafa7668]

Really useful video. Thanks for doing this. Looking forward for the next vedio.

[@AmitChandak]

There are already two more in playlist :) kzbin.info/www/bejne/pl7ZYXxriJKsmNU

[@saketsrivastava84]

Thank You Sir for your efforts.😇

[@AmitChandak]

It's my pleasure. Thanks. Hope you are having a look at rest of the videos 10- Videos kzbin.info/www/bejne/pl7ZYXxriJKsmNU

[@saketsrivastava84]

@@AmitChandak Sure sir I will watch all the recording it's very good and only few content creators are focusing on fabric and I am interested in learning fabric.

[@sanishthomas2858]

Nice. so that means we don't use or have the concepts of dedicated SQL Pool which usually was very costly?

[@AmitChandak]

@sanishthomas2858 , here we have a capacity which can be used by multiple experiences like SQL/Spark/Power BI/Data factory etc. We can use multiple capacities as per need. Each workspace can have it own capacity. All workspace can use one capacity, if needed.

[@paridhimaheshwari3844]

Why can't i see defualt dataset in any of the two?

[@AmitChandak]

You should be able see Default Sematic model(Name changed), UI has changed a little bit, now it show as hierarchy

[@KrishfromIndia]

Thanks a lot ! Videos are very helpful. I activated Microsoft Fabric trial license and also enabled it at tenant level.. However i donot see the Microsoft Fabric features showing up in the new Workspace created. Could you please help me on this.

[@AmitChandak]

Hope the workspace is a trail workspace. After you create first Lakehouse, it should show all features

[@jasjyotsingh2007]

When you say lakehouse sql endpoint only supports reads does it mean we cant perform updates or inserts just like we could do in spark sql? Is this a drawback

[@AmitChandak]

On Lakehouse we can run Spark SQL, we can not run write using SQL end point SQL Managing Microsoft Fabric Lakehouse using Spark SQL: Data Manipulation Insert, Update, Delete, Alter #42: kzbin.info/www/bejne/hqbRfJWwac52e8k

[@jasjyotsingh2007]

@@AmitChandak Thanks can you please make some more videos on Dataflows Gen2 . I guess Fabric has not addopted Mapping Data flows and Data Flows gen2 as an ETL looks pretty confusing and backdated compared to Mapping Data flow. A series of video on Dataflow Gen2 should help

[@amolkulkarni1104]

Dear Can we activate trial version by using our personal email id pls share the process for , as got free fabric account but not able create any item on fabric why it is so please guide on it

[@AmitChandak]

Please sign for free M365 trail, using that you should be able to get Fabric access learn.microsoft.com/en-us/power-bi/enterprise/service-admin-signing-up-for-power-bi-with-a-new-office-365-trial Rest you can follow from here and my video.

[@Laughing_out_loud_]

I am a new subscriber. But you are a well known name to me. I have a couple of questions: What is the pricing for Fabric? My work involves ETL from OLAP (cubes) through SSIS packages on an On Prem SQL server and then connect PBI for reports development. Can Fabric replace this entire process? I have been asked to move my on prem SQL server to Azure now, do I need to set up a VM in Azure and shift my entire process on the Azure VM or leverage Fabric or set up ADF and Azure SQL server. Given the fact that I do not have any experience on Azure and will be a beginner, I would really appreciate any advice.

[@AmitChandak]

From on-premise you should be able to move data using latest on-premise gateway kzbin.info/www/bejne/pXapXp1-i9KpmtE You can also transform data using Dataflow gen 2 and SQL Incremental 2 -kzbin.info/www/bejne/p6SyepmKr892ibM Incremental 1- kzbin.info/www/bejne/o6Gpg6GQd72mrLM