Forum Discussion
Change semantic model source in mixed storage mode
Hey colecrouter ,
for me everthing works fine again with the new update.
Im using the Version: 2.137.952.0 64-bit (Oktober 2024)
Can you confirm the same?
It seems to be working for me now, using Version: 2.137.1102.0 64-bit (October, 2024). I hadn't checked my version beforehand, so maybe it has been patched, or my problem was isolated.
Here are some steps you can try:
-
Check for any external dependencies: Ensure that your semantic model source isn't being used by another process, which might cause the freeze.
-
Clear cache: Sometimes Power BI caches can cause issues. Clear the cache in Options > Data Load > Clear cache.
-
Disable preview features: Try disabling any preview features in Power BI Desktop under Options > Preview Features. Restart Power BI and try changing the source again.
-
Try with another dataset or model: Create a new Power BI file, connect it to a different semantic model, and see if the issue persists. This will help you identify if it’s a problem specific to the report or the model.
-
Update or reinstall Power BI Desktop: Ensure that you're on the latest version of Power BI Desktop. You could also try uninstalling and reinstalling the application to see if that fixes the issue.
-
Look for workspace permissions or connection changes: Check if the new semantic model source you're trying to connect to has the right permissions, or if there were any recent changes in the dataset's workspace or security settings.
I tried everything exept point 5. I cant manually update or uninstall and reinstall. Everything is managed by our organisation automatically.
With the new Power Bi file i created everything works fine and I can change the data source when there is only 1 connection to a semantic model. As soon as i add another data source for example an excel file i cant change the data source for the semantic model anymore. It doesnt matter to which semantic model i connect.
Hi Christian_S
When your file uses “Mixed” storage mode (e.g., it connects to both a semantic model and another data source like Excel), the “Change Source” function for the semantic model often becomes disabled or causes Power BI to freeze. This is expected behavior, and unfortunately, there’s no fix yet.Workarounds:
-
If possible, remove all other data sources (like Excel), change the semantic model source, then re-add your additional data sources.
-
Or, create a new PBIX file with the desired semantic model connection, then re-import your visuals or queries.
This limitation affects all current versions and isn’t resolved by updates or reinstalls.
Hopefully, Microsoft will address this in a future release. For now, using a new PBIX or removing secondary data sources temporarily is the best solution.-