Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ihartdata
Employee
Employee

Shared Data Model: Pushing new calculated columns and dimensions

I have created a PowerBI Report in PowerBI Desktop. I then publish this report into my App workspace.  I now want to create a seperate PowerBI Report in a separate PBIX file, but using the same data model from the first. I know how to do this just fine. 

 

Before I start creating this second report. Is there a way to ensure that if changes are made to the model created in the frst, that they will be reflected in the 2nd report? For example, can I create a data model, upload it to the App Workspace. Download the data model, create a 2nd .pbix, publish it to the app. And then add new dimensions and new calculated columns to the data model that will propegate in all of them? 

 

I have read so many help articles, but it's hard to read between the lines, so now I'm unsure. 

1 ACCEPTED SOLUTION
edhans
Super User
Super User

Open up the Power BI Desktop with a blank file. Select Get Data, then Power BI Datasets.

Point to your workspace, then your data set you want to be identical.

 

Basically, the new file will treat the old file as an SSAS data source. It never needs refreshing, and will always reflect the model in the original. Change the model or refresh the data in the original and the copy will always be in sync.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

3 REPLIES 3
edhans
Super User
Super User

Open up the Power BI Desktop with a blank file. Select Get Data, then Power BI Datasets.

Point to your workspace, then your data set you want to be identical.

 

Basically, the new file will treat the old file as an SSAS data source. It never needs refreshing, and will always reflect the model in the original. Change the model or refresh the data in the original and the copy will always be in sync.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Thank you @edhans !! I really appreciate the simplified instructions. Reading through all the different articles on data sets, content packs, etc. was just confusing me! 

You're welcome. Right now the downside is you can only create new reports to datasets in the same workspace. We are supposed to be getting a feature in the service that will allow us to create a report in Workspace B based on a dataset in Workspace A, but it isn't here yet.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.