Forum Discussion
Getting on premises data into Fabric
Hi joakimfenno ,
Thanks for using Fabric Community.
Unfortunately it is not possible to use/acess on premise datagateways from notebooks. At present we can use on premise data gateway only with datapipelines and dataflow gen 2.
As an alternative, you can load your data into lakehouse from onprem using pipeline and you can perform transformation for data present in lakehouse using Notebook after loading successfully.
Docs to refer - Integrating On-Premises Data into Microsoft Fabric Using Data Pipelines in Data Factory | Microsoft Fabric Blog | Microsoft Fabric
However, your suggestion is definitely valuable! We use customer feedback like yours to prioritize future features. The more users who request the ability to customize backgrounds, the higher it moves on our list.
Appreciate if you could share the feedback on our Microsoft Fabric Ideas. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.
I hope this information helps. If you have any further queries please do let us know.
Thanks for getting back.
Apart from data gateways - are there other options for enabling on premise data sources (in my case web API, postgres db, kafka server etc.) for fabric or for azure in general. Is it possible to open up a on prem service for fabric in a secure way?
Hi joakimfenno ,
Please refer below links -
Loading on-prem DB to Fabric Lakehouse with Synapse Spark (youtube.com)
Microsoft Fabric: Load on-premise data file to Lakehouse using on-premise Python using OAuth Token (youtube.com)
Hope this is helpful. Please do let me know incase of further queries.Hi joakimfenno ,
We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .
Thanks
