Can't re-establish connection to re-published shared dataset

[SunnyUbhie]

Hi,

Someone in the team deleted a shared dataset, along with all its reports from the workspace and republished the dataset again.

Unfortunately, when we try to open pbix files that link to this shared dataset in the desktop to publish them we get the below error.

If I click Retry the error pops up again and if I click Edit the error goes away but nothing happens.

We are all admins of this dataset and I've put the team as admins/owners in the Security (as there's RLS on this report) and Manage Permissions of the dataset.

All I need to do is open these files to publish them but can't figure out how to do it.

Does anyone know how I can fix this?

Thanks

Sunny

[v-deddai1-msft · Accepted solution]

Hi @SunnyUbhie ,

Please try the following steps and you will create a link to the new dataset you re-publish :

Open Blank Report in power BI Desktop.

Sign-in Power BI Desktop with credentials of power BI Service where dataset is published.

Then go to file > Open > open your report (from location where you saved report).

Then you will see the same error message in your original post, click edit and you will be able to choose the new dataset for your file:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[SunnyUbhie]

Hi, you are my hero. I can't believe this worked.
It’s strange that it doesn’t work when opening the pbix file directly but it does when opening from within a blank Power BI Desktop.

[v-deddai1-msft]

Hi @SunnyUbhie ,

Would you please try to change dataset in Data Source setting.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[SunnyUbhie]

As I stated in my original message, I'm unable to open the report files to make that change.