Forum Discussion

Copycat's avatar
Copycat
Frequent Visitor
2 years ago
Solved

Connect two reports between env after deleting one.

Good day beautiful people,

 

I have one report called AT and dataset AT - Dataset. It was deployed from dev to test and prod via pipeline.

 

The issue is, that a report on dev was deleted and replaced by the same one but it seems that PBI service lost connection between dev and test. When I'm deploying from dev to test, it wants to create a new one which is not desired situation since I would like avoid to create a new one (users are grumpy when the link changes).

 

My question is, can I somehow restore the proper connection without changing the report?
I saw a post on reddit, that suggested to "unpin and pin back again" whole dev environment so it will be connected again, but to be honest it seems like an overkill. If this is the correct way, let it be but maybe someone got different idea?

Need Help
  • Copycat's avatar
    Copycat
    2 years ago

    Thanks aj1973 for your info but I believe I can propose a solution. My senior took the wheel and he managed to restore the connection.

     

    We had a copy of our report, stored locally and what he did was:

    • Unassigned dev workspace
    • Uploaded report, connected to correct dataset
    • Assigned dev workspace
    • Waited for refresh
    • Works!

    I'm surprised that this successed but I believe Microsoft changed something in recent months, since this solution was failing months ago.

     

    Before anyone will try this at home, please make sure that both environments contains the same since we had some errors with testing .pbix files and we had to delete them.

2 Replies

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi Copycat 

    Unfortunatly once a report is deleted it loses its ID with it, that's why the connection is lost between Dev an Test.

    You can't restore the report nor the connection.

     

    • Copycat's avatar
      Copycat
      Frequent Visitor
      2 years ago

      Thanks aj1973 for your info but I believe I can propose a solution. My senior took the wheel and he managed to restore the connection.

       

      We had a copy of our report, stored locally and what he did was:

      • Unassigned dev workspace
      • Uploaded report, connected to correct dataset
      • Assigned dev workspace
      • Waited for refresh
      • Works!

      I'm surprised that this successed but I believe Microsoft changed something in recent months, since this solution was failing months ago.

       

      Before anyone will try this at home, please make sure that both environments contains the same since we had some errors with testing .pbix files and we had to delete them.