Quick answer - you will use two of these methods (Power Query and Dataset) and perhaps all three.
Long Answer is more of an explanation:
Power Query - the ‘shaping’ or transformation of your data using M code, this is used in both Datasets (which are multiple queries brought together into a single model), and in Dataflows
Dataset - this is what we call the entire data model, with multiple tables pulled together for the report
Dataflow - this is really Power Query that happens out in the PowerBi service, but it allows you to have a refresh on the individual tables that you are bringing together into the Dataset.
If you mean something different with your use of “Power Query”, “Dataset”, and “Dataflow”; please let me know so I can comment again
Here are some resources that might help to better understand this:
I haven’t used dataflows, so don’t have anything substantive to contribute to this thread, but I did remember seeing this informative post from @Melissa, which does provide some information that seems relevant to your questions:
I am attempting to use a single Dataset for multiple Workspaces.
The idea is to create one go-to Dataset with a fairly comprehensive model, and use that one dataset for multiple workspaces so that I can publish three apps for different user groups.
I was able to create a new workspace with a linked dataset from another workspace. However, I can’t figure out how to publish reports into this workspace. I create a new pbix file and connect to the existing published dataset. Howev…
I have presented about Power BI dataflow and datasets a lot, and always one of the questions I get is: What is the difference between dataflow and dataset. So I thought better to explain it in a post and help everyone in that understanding. In this...
Est. reading time: 5 minutes