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 a...
Need Help
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 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.