Every Azure Synapse Analytics Engineer Needs to Know this Essential Dataverse Feature - Synapse Link

[@MSFT_ScottSewell]

Love this @Andy! - Fantastic introduction to a very cool feature. 😀

[@DatahaiBI]

Thanks Scott. I’ll be looking at snapshots next

[@BhupendraPatel1978]

awaiting the next video in the series Andy!!

[@DatahaiBI]

I’ll post a couple of diving into the snapshots and metadata

[@ivonakobrlova7998]

Perfectly explained, thanks!

[@geehaf]

Absolutely outstanding video. Thanks. Off to watch part 2!

[@tarunacharya84]

Thanks Andy, very nicely explained 👍

[@DatahaiBI]

Thanks, hope it helps

[@SilvanoPaxia]

Great Job Andy! I'm just working at a Project that need to manage few million rows in Dataverse using a Model Driven Apps and only way for me to create to a BI is to use Synapse links. Other options like Direct Query or Import will have issues. Either because of the governor or the 80 MB limitation on the SQL Interface.

[@DatahaiBI]

Yes the limit via TDS endpoint is very limiting. Let us know how you get on

[@SilvanoPaxia]

@Datahai BI, the end result of the project was successful. However, there were a few challenges with the Synapse Link. The near real-time feature may not be as useful as it seems, as if the app has a large number of concurrent users, the files in the lake database can often be locked, resulting in the need to rely on less fresh data, making the near real-time feature not very helpful. Another issue is that the Synapse Workspace must be located in the same region as the PowerApps environment. In the US, you are unable to choose a location, so you may end up having the lake database in one location and your existing data lake in another location.

[@BritonWells]

@@SilvanoPaxia FYI on the last part - MS support can move a power platform environment across regions so you can match your existing azure region

[@raghuramsharma2603]

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