Thank you for a nice video in a really nice pace. Not too short and not too long. Thanks.

will it work with postgre on-prem database?

This is very nice!

This could be nice! If I could do iSeries/AS400.

Great Video!

but why to convert in delta format, could not i directly use serverless pool or spark on dataframe?

What I don’t understand is why you would create the lake database in the Serverless pools however (ie not in the spark notebook. Love your videos btw!

Your tutorial is really helpful, mate. Big thanks!

useful description but most people want to know when to use one versus the other (which problems each are designed to solve) and this isn't discussed.

why is the spark pool not being picked up on our setup. It's in the same workspace and and resource group?

Great explanation.

Thanks so much Andy, unfortunately 😊 with D365 Finance & Operations the Append Only is ON and cannot be modified, please advise what SQL query should be used to avoid duplications and just take the last version of the rows.

Thanks for the great video. If I have a requirement to get this data into Azure SQL DB. CRM -- > Synapse link -- . Microsoft Data fabric -- > SQL . Does this make sense.

When I select my spark pool, the storage account drop down is empty. Otherwise, the storage account dropdown is populated. Any idea?

Super usefull, Andy. Thank you!

Which one do you think is worth to take first dp-203 or dp-600? I am already pl-300 I see that Fabric is the next step in my PowerBi career but I dont know if the market is growing in this direction yet, what are your thoughts?

Great explanation! Subscribed immediately

Hi Andy we have this requirement in our current project...but we are facing issue and moreover we are using "Select Enterprise Policy with Managed Service Identity"...Any pre configurations if you are trying with Managed Service Identity? Can you pls help thanks

Very nice video! I was looking at your channel to see if I could find a way to set up the "BYOL" concept through a synapse link. According to Microsoft Techtalks, it should be possible to export Dynamics tables into Data lake without an Analytics workspace. I even saw it briefly during one of the techtalks, however they never explained it in detail. When I tried it, my Finance and Operations tables aren't visible to me unless i choose the analytics workspace and a spark pool. I'm finding the Microsoft documentation extremely confusing regarding this. Any ideas?

Just a tangential comment he has the same vocal intonations as George Michael

Good afternoon, I am having problems develoing this process. I have done everything but my sync status in my azure synapse link go from "Initial sync in progress" to "Error" without giving any further information. If I go to my data lake, the selected table is inside it but with CSV format not Delta. The only difference is the connection is from Dynamics F&O. Do you think that the problem can come from LCS Dynamics F&O? Thanks in advance.

When to use Lake Database and when to use to SQL Database in synapse?

Had to change speed to 1 25...you talk too slowly.

Hi Andy, thanks for this walkthrough. My basic question is why is it acceptable to have to run compute (additional costs) and make copies (additional costs) of data from Lakehouse to Warehouse when with Azure Databricks, the Lakehouse is one compute execution, one security model, one copy of the data, etc. Fabric has separate capacity and security models depending on where you are coming from (and they don't carry through, ie security model doesn't move with the data). Fabric Shortcuts break the security model.

Very useful. Thanks for sharing

Looking forward to this one - all your resources were the backbone for me getting to grips with DP 500.

My understanding from Azure documentation is a bit different. As I understand, Fabric warehouse is essentally the same fabric lakehouse on spark. The diference is, to make warehouse sa called ACID compliant, they restricted spark side of things to give more capability to the sql end point part. It is not the SQL Server we know.

In the documentation Microsoft mentions: "For the Dataverse configuration, append-only is enabled by default to export CSV data in appendonly mode. But the delta lake table will have an in-place update structure because the delta lake conversion comes with a periodic merge process." Does that mean that when we delete a row in Dataverse, the latest version of the Delta table has no record of the record? If so, do older versions of the Delta file still contain the deleted record, or does the 'once per day optimize job' remove that history?

"Throwing in a Power BI custom report theme - that's interesting" -> I thought exactly the same 🤣 Great video Andy - very well laid out 👊 exciting times ahead!

Youre providing great content please continue your good work and kindly provide lengthy explanation videos with a practical example consisting a complete pipelines from start to end

Great video thanks! There are still some bugs with serverless sql pools though.. Also, how will it go during deployment of external tables ? It requires a valid path on the data lake to create the external table. So if it's a new external table not yet available on the target environment, the deploy will fail.

Will this work when we have views dependent on views in other databases? In our setup we have logical data warehouse, dims and facts view depend on views in other database that have views over delta lake files.

Great video, thanks.

Very, very helpful info. Thank you for showing the Fabric side of domains. This is exactly the info I was looking for. Liked & subscribed. :-)

Good content but long-winded; take out the local weather report and the 'maybe' technology and an hour+ video is reduced to half. There's definite value here but people's time is important to them.

Great video

Thank you for such good content. The way you calmly explain the basic concepts is fabulous, would like to binge on other videos of yours.

Very nicely explained.. you now have a new subscriber. keep creating more content.

nice video! when to use Lake Database and when to use to SQL Database in synapse?

This tute is amazing - thank you!

do you have any pre-built infrastructure scripts to establish resources for the examples? be great to include

Was a hard exam, but well worth it!

Great video, thanks.

Thanks for demo!! great resources videos

Hi Andy, Thanks for the useful video! Just a quick question - when your workspaces are in a deployment pipeline, do you know if they can still be put on different capacities as you describe? Or do all workspaces in a pipeline have to be on the same capacity? Don't worry if you don't know, I can try it out and comment the answer here!

Thanks for great explanation - does this mean that 15 minutes is as low as we can get in terms of latency? What solutions would you recommend if the requirement is to detect change in data in sub-minute (or ideally couple of second) range? Thanks

Great video. Thanks.

The sql endpoint is definitely like the synapse server less sql pool. I'm a little surprised that we don't have something like cetas, tho. Maybe it's coming.

Nice video, one suggestion it's a video covering end-to-end data warehouse, since loading data from source, create the layers and what happen on each layer and then incremental load facts and dims on gold layer with surrogate keys.I mean from people like me that come from "traditional" B.I, it's not to easy to understand. This could be done a video for synapse using serveless.Cheers and thank you for your videos, help us a lot.

Very succinct and valuable introduction to the new Fabric Lakehouse and Warehouse. Good stuff!