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
Element115's avatar
Element115
Memorable Member
2 years ago

Can you migrate some of the data to a lakehouse? Perhaps an aggregate version of the source data? Storage cost is very inexpensive from what I've seen.

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.