Activity
Mon
Wed
Fri
Sun
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
What is this?
Less
More

Memberships

Learn Microsoft Fabric

12.7k members • Free

6 contributions to Learn Microsoft Fabric
Custom schedule for data pipeline
I would like to schedule a data pipeline to run from Tuesday to Saturday every week. How can I do that in Fabric? The pipeline scheduler only allows for by the minute, hourly, daily, weekly and monthly schedules.
On-prem oracle with SPN
Hello, Is there a way to connect to an on-prem oracle database using service principal entra ID to ingest data into Fabric through the on-prem data gateway? At the moment, the authentication uses Basic with username and password. Could a SPN application ID and password be provided in this basic authentication? And if this is a limitation, is it on the Fabric data factory roadmap somewhere that I can find? Thanks in advance.
0 likes • Apr 23
Yes, you will need to install Oracle client Microsoft tools (OCMT) on the data gateway server, setup the connection in MS Fabric using service principal as the authentication method, create a data pipeline to move data from the Oracle DB to the destination LH or WH in MS Fabric.
Error when writing on premise SQL server DB data to Fabric Lakehouse
I am getting this error when I am trying to ingest the data from on premise SQL server table to Fabric Lakehouse table - Something went wrong while retrieving the list of tables. Please try again later.: An exception occurred: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)
0 likes • Jan 21
@Will Needham I am using the on premise data gateway and dataflow gen2. I guess there are some firewall rules required to be configured to enable writing to the Fabric Lakehouse.
[FAQ] For On-Premise SQL Server users...
If you have any further questions on this topic not covered in the article: #For on-prem SQL Server users ... ASK BELOW 👇👇
0 likes • Jan 17
I am getting this error when I am trying to ingest the data from on premise SQL server table to Fabric Lakehouse table - Something went wrong while retrieving the list of tables. Please try again later.: An exception occurred: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)
Studying for the DP-600 Exam? Watch this!
Sharing a recording of the 2.5hr DP-600 Exam Cram (aligned to the new study guide) I participated in alongside lots of awesome presenters! Hope you enjoy! I have also added it to the DP-600 classroom: #2.5hr DP-600 EXAM CRAM (new study guide)
2 likes • Dec '24
Nice informative session. Is it possible to get the session presentation @Will Needham ?
1-6 of 6
Rohan Naik
2
15points to level up
@rohan-naik-7393
data enthusiast, currently working as a Fabric platform Engineer

Active 5d ago
Joined Oct 2, 2024
Toronto
Powered by