Forum Discussion

AndrewWestran's avatar
AndrewWestran
Helper I
2 years ago

Dataflow and PowerBI Gateway - Sourcing data dynamically

Hi all,   I have a Dataflow Gen2 which is sourcing data from an on-premises SQL Server via PowerBI Gateway. The server contains many databases, each representing a retail POS. These databases may...
Dataflows
AndrewWestran's avatar
AndrewWestran
Helper I
2 years ago

Thanks for your comment, Element115.

To manage this migration to the lakehouse without the dynamic DB access capability, we would need to move the functionality to the source system, e.g., export the data to Azure Blob storage and then import it into the lakehouse.

This is our only alternative at this point and is unnecessarily complicated, where Fabric touts a unified toolset, which falls short in this scenario.

v-cboorla-msft's avatar
v-cboorla-msft
Microsoft Employee
2 years ago

Hi AndrewWestran 

 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.


Thanks.

  • AndrewWestran's avatar
    AndrewWestran
    Helper I
    2 years ago

    Hi v-cboorla-msft 

     

    I have responded to all replies on this thread.

    Please let me know if there is a specific comment that I have missed.

     

    Many thanks

    • v-cboorla-msft's avatar
      v-cboorla-msft
      Microsoft Employee
      2 years ago

      Hi AndrewWestran 

       

      Apologies for my previous comment. I just wanted to check whether your query got resolved. If no please let us know. 

      Otherwise, will respond back with the more details and we will try to help.

       

      Thanks.

      • AndrewWestran's avatar
        AndrewWestran
        Helper I
        2 years ago

        Hi v-cboorla-msft 

         

        No problem 🙂

        This issue is not resolved.

        I would be interested if this functionality is possibly supported by Notebooks/PySpark or other features of the Fabric environment. Perhaps I have missed something.

         

        Regards