Friday, August 30, 2024

Split a Power BI (PBIX) File into a Stand-Alone Dataset


Sometimes you just need the steps.  This is one of those times.  This enables you to use the same dataset across multiple reports, further enabling you to update the model continually across multiple reports without having to access each report.  Obviously, you would want to validate that changes don't break the other reports. 

The essential points of this video are to ...

  1. Build the model and report.
  2. Save Report-1
  3. Save As Report-2
  4. In Report-2
    1. Add a new blank tab
    2. Delete all other tabs
    3. Publish
  5. In Power BI Service,
    1. Delete Report-2, but not the dataset
  6. In Report-1,
    1. Transform
    2. Delete the model and all queries
    3. Close & Apply
    4. Save
    5. Get Data
      1. Choose Report-2 dataset in Power BI Service

Thinking about this further though, I still have one question.  What performance difference is there, if any, between doing this and simply having the originating report and dataset in place, and simply attaching to that originating dataset as needed for other reports?  All of these dependencies look the same in the Power BI Service, whether split or not.



No comments:

Post a Comment

Popular Variations