Forum Discussion
Help changing a report's semantic data model
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.
I have a similar issue, but transform data doesn't do the trick for me. For some reason it is not recognizing that the report is already using a semantic model but at the same time I'm not able to assign a new one because it is just allowing me to create a new direct query connection by entering Server\tabular.
I noticed that the option via transform data just exist for the originally created file. Once it is uploaded to PBI service and downloaded again for editing this option doesn't work anymore. Is there an alternative way? It seems like such a common thing to change the data connection taht it's weird it is that limited.
Did you ever find a solution to this? I am exeriancing the same thing. Some reports pull up the data source and others just say connect ot a new model even though it is allready connected.
The solution, as silly as it sounds is to make sure, noone ever downloads a report from power bi to edit it locally. Instead, the "valid" version always needs to be stored in the version control tool used. We're also experimenting with the git integration in power BI services to see if that improves the situation. But we havent found a way to fix the error, if its created
