Forum Discussion

NovaBI's avatar
NovaBI
Post Patron
3 years ago
Solved

Given Dataset + Report - how to split - best practice?

Hi all,   we have the following situation: a user has created a huge dataset + report with multiple sheets (every sheet represents one "report" (not in a pbi sense obviously)).   As this was alwa...
  • ibarrau's avatar
    3 years ago

    Hi. It's a very good idea to keep a single datasets with a good data modeling to fill many reports live connected there. If you want to migrate the sheets from the original file you can just copy past from two PBI Desktop files. Open the original dataset with many sheets and open a blank one. Create a live connection to power bi dataset on service with the blank one.

    Then you can just open the sheet you want to migrate, select all components (like ctrl + A), copy and paste it on the blank one with live connection. Everything should be there. That way you can delete sheets from the original and create reports connected to a single dataset without replicating the dataset on each publish.

    I hope that make sense