Forum Discussion
Changing from Direct Query to Live connection without changing report sharing link url
Not easily. It is usually a one way street from Live to Direct Query to Import Mode. You would have to patch the PBIX or PBIP file(s).
Sometimes you can cheat by renaming your new PBIX version to exactly the same name as the original version and then either publishing the PBIX or uploading it from the service. Sometimes. You might get an error message, or you might still get a different GUID.
Prepare your plan B - Management of Change to inform your report users about the URL change.
Not easily. It is usually a one way street from Live to Direct Query to Import Mode. You would have to patch the PBIX or PBIP file(s).
Sometimes you can cheat by renaming your new PBIX version to exactly the same name as the original version and then either publishing the PBIX or uploading it from the service. Sometimes. You might get an error message, or you might still get a different GUID.
Prepare your plan B - Management of Change to inform your report users about the URL change.
Thank you lbendlin . When I changed from import to direct query it was ok. Then when I changed from direct query to live connection I had the problem. So I think I will revert to direct query as that was allowing the file to overwrite / the sharing link to stay the same. It's just annoying there are extra semantic models in the workspace, and there is the risk of developers adding calculated columns/measures to the thin files.
