Forum Discussion
kky1
Helper II
Helper IIHelp changing a report's semantic data model
Hello - I have an existing report that has a direct query connection to a semantic data model. In the same workspace, I've developed a v2 of the semantic data model with additonal measures, etc. I've...
kky1 Try going to Transform data and switching all of your Source steps to point to the v2 data model instead of the v1 data model. I tested this by setting up directquery queries to AdventureWorksDW2019 database and then switching them to AdventureWorksDW2022 database.
kky1Helper II
Helper IIThanks so much Greg_Deckler - that did the trick! I guess I was afraid to click "Submit" on the pop up with the first data model tables, but once I did that went to Transform Data, I could see all the data models and was very easy to select the one I wanted. I feel a bit silly for not being able to figure it out on my own, but thank you so much for the response!!
- Greg_Deckler
Community Champion
kky1 Well, I wouldn't feel bad or silly, not exactly an intuitive and straight-forward way of doing it.