Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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~

Need Help

6 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    Anonymous , 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

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

       

  • hvnter's avatar
    hvnter
    Resolver I
    2 years ago

    Good morning Anonymous,

     

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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. 

      • hvnter's avatar
        hvnter
        Resolver I
        2 years ago

        Good afternoon Anonymous ,

         

        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