Forum Discussion

PowerWhy's avatar
PowerWhy
Helper IV
1 year ago
Solved

Changing from Direct Query to Live connection without changing report sharing link url

Hello,   I changed my report's data connection method from direct query to live link. Unfortunately when I publish this to service it is displaying as a seperate report instead of overwriting the o...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    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.

lbendlin's avatar
lbendlin
Super User
1 year ago

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.