Forum Discussion
Update Data Source for Multiple Datasets (Same source, just updating the server) Whats the best way?
rodneyc8063_1 - Generally think of a dataflow as equivalent to a Query in Power Query. So typically you are accessing a single data source and performing transformations on it. You can then connect to this dataflow from Power BI Desktop and use it as if you had built the query in the Power BI Desktop file. So, if I understand correctly, in your case you would create 20 dataflows. Users could mix and match these dataflows to build datasets in their own Power BI reports in Desktop.
For a Golden Dataset approach, you can create report level measures with a Live connection.
https://radacad.com/live-connection-when-power-bi-comes-hybrid
They cannot prune out tables or hide tables or hide columns, etc. You also cannot create new calculated columns so your options are limited.
Hi Greg_Deckler
Ahhhh
Hm ok one last question regarding the "Golden Dataset" approach - I did some reading up, and it sounds like you said, tables can not be removed.
So is it safe to assume that also for the relationships are also unable to be edited?
Dataflows does sound like its the more flexible option in this case, as that would allow an end user to pick and choose, and set up relationships on their own if needed.
rodneyc8063_1 Correct, you cannot edit the relationships