Forum Discussion

AndrewWestran's avatar
AndrewWestran
Icon for Helper I rankHelper 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
Icon for Memorable Member rankMemorable 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
Icon for Helper I rankHelper 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.