Load Data from OnPremise Database into Fabric Lakehouse

[@quiosaevaristo7746]

Hi, Thank you for the wonderfull content. I want to know how can we manage incremental loading and apply some types of slowly changing dimensions according to my business requirement

[@TheOyinbooke]

Thank you for your question. This will inform my next content.

[@akthar3]

great video walk-through. i have not yet tested it but been through the video

[@taoridirafiu8289]

Thanks for the video. This is what I've been looking for, took me a while to figure out my windows password though.

[@NaaneVinu]

Here once again. I did not observe how you could able to fetch the data from views and store in destination data sets :). Can you please explain or make another vide on this is possible? OR did I did miss somewhere here? Thank you, for these videos.

[@TheOyinbooke]

Thanks for the question. I will drop a video on this before the weekend

[@lerbous4633]

can i set dynamic load table from on Prem SQL server in Fabric?

[@FaruqAtilola]

Thank you.

[@mageshwarans5367]

Your videos are awesome

[@TheOyinbooke]

Thank you for the encouragement Mageshwarans5367

[@jucamvil]

That works, but it's not the right way to import raw data into the lake. You should use the "Copy Data" activity. And the gateway won't work that way.

[@TheOyinbooke]

You're right but as at the time of making the video, data factory pipeline couldn't connect to the data gateway. It requires integration runtime server and links to be created. If the data volume is not larger, this approach works fine. I am working on the other video for copy activity

[@seyiabayomi]

Thanks for the video. However, I followed all the instructions as shown, I couldn't access SSMS and got this error message: Invalid credentials. (Session ID: ........, Region: us). What am I doing wrong?