Forum Discussion

Xaraja's avatar
Xaraja
Icon for Helper III rankHelper III
4 years ago
Solved

Fix a Mess - Datasets, Dataflows, Lots of Duplication

I'm beginning a huge project to bring order to a massively chaotic Power BI ecosystem where there's a lot of duplication of datasets. There are also a few dataflows, but I'm not sure from what I'm re...
dataflow
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Xaraja Dataflows simply allow you to reuse queries across multiple datasets, no memory benefit. To future proof, just make sure to use query parameters for your source and database names and to create a single query that is referenced by all other queries. This reference query would use the query parameters and would be set to disable "Enable load" and all it would do is connect to the server, so just a single Source line and no other steps.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

Xaraja Dataflows simply allow you to reuse queries across multiple datasets, no memory benefit. To future proof, just make sure to use query parameters for your source and database names and to create a single query that is referenced by all other queries. This reference query would use the query parameters and would be set to disable "Enable load" and all it would do is connect to the server, so just a single Source line and no other steps.