Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

spicydisaster

Unable to change the Semantic Model a report is linked to

Submitted by on ‎11-05-2024 02:14 PM

Having this issue since the October 2024 launch, functionality previously existed: change data source of report from Semantic Model A (SMA) to Semantic Model B (SMB) instead. 

In the Desktop version of PBI, I have a report open that is currently linked to SMA. I've loaded SMB into the same workspace that SMA exists (close copy, slight changes in column names and table names to standardize).

Within the report, I go to 'Transform Data' -> 'Data source settings' and it opens up to the screen below. This does not have the option to change source, only to connect to additinal models. Same results if I go to 'File' -> 'Options and settings' -> 'Data source settings'.

There used to be a button "Change source" that would allow me to choose SMA and then change it to SMB. I can't figure out how to change the semantic model a report is linked to and don't want to manually recreate every report page, visual, and filter setting.

 

spicydisaster_0-1730844845324.png

 

Version today 11/4: Version: 2.137.1102.0 64-bit (October 2024)

 

Status: Investigating
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎11-05-2024 11:22 PM

Hi @spicydisaster ,

 

If I understand correctly, if you connect to SMA from Power BI Desktop using live connection mode, you will not be able to modify this data source in Power BI Desktop, this is by design and an unsupported feature that I have been testing in Power BI Desktop for the last six months.

You can try other connection modes such as import and the change datasource feature works fine.

 

vxiaoyanmsft_0-1730877663036.png

If I've misunderstood, please be free to correct me.

 

Best regards.
Community Support Team_Caitlyn

 

Idea Statuses