Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Fabric Question regarding On-Prem connections

Hi,

I have a question regarding the use of Fabric for small to medium businesses with on-premises databases. Can Fabric be used in such cases? Currently, we connect our on-premise databases to PowerBi using an on-premises data gateway and refresh the data using workflows and Power Automate.

I understand that Fabric lake house typically requires data to be in the cloud, but I noticed there are Lakehouse shortcuts/endpoints. Is it possible to still use on-premises data without uploading it to the cloud?

 

P.S. It would be really helpful if Microsoft added more documentation aimed at on-premises setups for Fabric.

Also, I noticed that Fabric has datasets in OneLake. Could you please clarify where dataflows are now located?

Thank you.

Martin N

dataflow
Need Help
Tips and Tricks
Tutorial Requests

4 Replies

  • edhans's avatar
    edhans
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Fabric is cloud. It can access on prem via gateways, but the magic happens when the data is moved to the cloud. There are no on prem fabric services like there are for Power BI (Report Server) or SQL Server (Analysis Services, SQL Server RDB, etc)

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Microsoft's documentation does not clearly explain how to utilize a remote gateway with Fabric. Although Fabric can access on-premises data via gateways, Microsoft's guidance lacks clarity on this aspect. Currently, our datasets reside on a lake and undergo an ETL process (PowerQuery Transforms/Shared Datasets) using on-premises data. It would be helpful if Microsoft provided more guidance on integrating Fabric with remote gateways in such scenarios.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Guy in a Cube helped me with this, but the solution isnt resolved because Microsoft doesnt provide guidance on this.

        1. Dataflows Gen2 (Supports the On-Premises Data Gateway)
        2. Pipelines (does not currently support the gateway)
        3. Notebooks (does not support gateway)
        4. Azure Data Factory (supports the runtime which is like the on-prem gateway – this could pump data into the endpoint for OneLake – basically OneLake is treated like Azure Data Lake Storage at that point).