On-premises data with Data Factory in Microsoft Fabric
Вставка
- Опубліковано 28 тра 2024
- Do you have on-premises data like a SQL Server? Want to leverage a pipeline within Data Factory in Microsoft Fabric? Patrick shows you have to get going and set that up!
How to access on-premises data sources in Data Factory for Microsoft Fabric
learn.microsoft.com/fabric/da...
📢 Become a member: guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/courses
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com/tools/
#MicrosoftFabric #DataFactory #GuyInACube - Наука та технологія
I Love U my friend, i have de the entire mornig looking for a solution to migrated all table from my on premise SQl to frabric in i find youuuuuuuu thx XD
Can't wait for on-premises Oracle to be supported.
I am able to connect to onprem oracle from power bi using oprem personal gateway.
@@manjeerakoya1513but cannot connect to the Fabric
This has a major bug. When copying to datalake, time zones are converted. This bug is known for about a month and still not resolved. There are at least few posts in MS Community. My issue is: SQL server stores all dates and times in UTC (without time zone information), but our server is not in UTC locale. All copied data is automatically converted to "local" time
Q: Hey Patrick, it’s great to see that we can do this via pipelines and dataflows with on prem but I’m having a difficult time figuring out how to get data from an onprem environment to a spark notebook.
Is this possible in the current state of fabric or can we only use data flows and pipelines for this currently?
Hi, I created a Pipeline in the same way as in this video and chose the option "Overwrite", however, everytime my pipeline runs, the data gets appended in the lakehouse table. Is this a bug that still needs to be solved? If not, could you please do a video for the Overwrite vs Append for On-Premises with an example?
Great Vid! Do you have any idea if Data Mirroring will be enabled to a SQL server through the gateway?
Hi, Patrick. Thanks a lot for the video! I have used text analytics in power query, but it also asks for the gateway. I couldn't find anything suitable among "Connection Type", is there any way to make auto schedule refresh for reports use text analytics?
Hello Patrick, I can see a folder (file) option in the data source of copy activity in Data pipeline. Are we able now to copy files form local machines one a data gateway connection of folder type is established? Will the files mentioned in that data source be unstructured or only structured semi structured?
Thanks
If I have an Analysis Services Cube on-premises. ¿How do I extract that data with the Data Pipeline?
This only copies data once or refreshes like with standard gateway connection?
Does this require Fabric Capacity or can it work with PB Per User?
It has a very annoying but that is not resolved for a month. It adds time by on prem timezone, so all timestamps are incorrect. Be aware before using
I’m a bit disappointed by this video: we already worked last
Month to injest data like this in Fabric.