Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Ingesting on premise data with notebooks

Hi, I have an on premise database with a running PowerBI gateway and this is how we connected to these sources previously. Now, the requierement is that we would recreate our ETL process in Microsoft...
Need Help
pipelines
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous 
Thanks for using Fabric Community.
Currently, Microsoft Fabric notebooks do not directly support connecting to on-premise databases through the Power BI Gateway. Fabric Spark doesn’t do the integration with PBI gateway.

As a workaround you can create a Shortcut in Fabric Lakehouse for your external data. This way you can query the data using Notebooks. For more information regarding Shortcuts please refer to this link:
https://learn.microsoft.com/en-us/fabric/onelake/create-onelake-shortcut

Hope this helps. Please let me know if you have any further queries.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    How would shortcuts help me in this case? It can externally connect only to S3 and ADLS. The data is stored on local databases.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Anonymous 
      Which database are you referring here? Can you please specify?

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Multiple local PG instances