Live connections to Power BI datasets
An optional but very important report planning and design decision is whether or not to develop the data model and report visuals within the same Power BI Desktop file or to separate the report from the dataset into separate files. As a general recommendation, if there’s any possibility that additional reports will be needed in the future based on the same dataset, the dataset and report should be separated into separate files and likely separate workspaces as well.
With Live connections to Power BI datasets, report authors can develop reports in Power BI Desktop files containing only the visualization layer (report pages of visuals) while leveraging a single, “golden” dataset. Increasingly organizations will isolate these source datasets, which are typically maintained by an IT or BI department, into Power BI workspaces that only the IT or BI organization has edit rights to. Report authors and users of these source datasets...
