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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Shure846
Helper II
Helper II

Use Semantic model in different report?

Hi - I've got 2 reports that are published to the PowerBI service that are using part of the same core data. How can I change one of the reports to use the semantic model that is already refreshing as part of the other report? Currently both reports are on scheduled refresh, but I wanted to take some of the load off the system for the second report. 

 

The source files are JSON's that are stored locally on my machine (if that makes a difference). 

 

Thanks in advance~

6 REPLIES 6
hvnter
Resolver I
Resolver I

Good morning @Shure846,

 

Go to your model tab of the second report and CTRL+A and delete the whole model.  Go back to your report tabl. You'll notice all your visuals break (intended).  Click on 'Get Data' and select 'Power BI semantic models' and select your published dataset from the list

Thanks - do I have to delete the entire model if only part of it is included in the published semantic model? 

 

Edit: I started a new report and added that semantic model, but now I can't add any of the other data that isn't part of that model. 

Good afternoon @Shure846 ,

 

I don't believe you'll be able to make it work like that, you may be doing it backwards. You can use a subset of a published dataset to build a different report, however, you can't go the other way.  My advice would be to choose whichever report is the bigger of the shared dataset and publish that as your 'golden dataset' and then reference a subset of that dataset in your other report using the method you tried earlier 

Got it. The reason that I'm trying to do this is because that the smaller dataset is being run through forecasting tools, and I'm relying on PBI to crunch the JSON files and export the data into CSV's. The larger dataset has both the history as well as the (newly) generated forecast numbers and historicals. 

amitchandak
Super User
Super User

@Shure846 , if the semantic model structure is the same. Open the report on the desktop, go to Home tab-> Transform Data -> Data model setting. It will open a popup to select a semantic model. Select the different one

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Thanks - this is the error message I get in the desktop app: 

Shure846_0-1718111778547.png

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.