Reid Havens on 24 Mar 2023 11:39:47
When developing lean/thin reports with live connections to Power BI Datasets. Add a feature to swap the connection from the shared dataset published to the Power BI service, to a local copy (PBIX) version of that dataset.
This would allow for real-time changes of the dataset to propagate to the report without needing to republish the dataset each time changes need to be made to the model that are required for the connected report. Attached below is the link to a visualization of this concept.
Otherwise the development process is either of the two below scenarios:
Scenario 1:
- Identify modification needed in the lean (live connected) report.
- Make change to shared dataset PBIX
- Publish shared dataset PBIX
- Refresh live connected report to observe changes
- Repeat if again if necessary or if anything was missed when making changed to shared dataset PBIX
Scenario 2:
- Recreate lean (live connected) report page temporarily in shared dataset PBIX: E.g. copy visuals, configure filter pane, etc.
- Make all required modifications needed for that page in the shared dataset PBIX
- Delete report page from shared dataset PBIX
- Refresh report page in lean (live connected) and make changes with new model configurations
- Publish lean (live connected) report
https://app.screencast.com/oTUCYxLIvqYpy