Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
SandyBL
Advocate III
Advocate III

Point Power BI Service to another dataset

Accidentally deleted an existing dataset where my Power BI report using the Power BI Service was linked to.  I reuploaded the dataset under another group.  is there a method to point my existing Power BI report to the other dataset location?  Or will I need to recreate the report with all the visualizations? 

1 ACCEPTED SOLUTION

I did only copy the connection file and have the latest powerbi.

 

Note that I ended up fixing it by restoring the group/workspace that was accidentally deleted by a collaegue. 

View solution in original post

6 REPLIES 6
v-ljerr-msft
Employee
Employee

Hi @SandyBL,

In SU08, this feature is going to be generally available. We support rebinding the dataset in the PBI Desktop. So, if user deletes their data set in service. In Desktop they can rebind to another dataset.

I have got a information that a new feature which supports rebinding the dataset in the PBI Desktop is going to be generally available in next release of Power BI Desktop((Aug 2017)). Smiley Happy

 

Regards

That's great

GilbertQ
Super User
Super User

Hi @SandyBL

 

You could re-connect it again, but it is a bit of hacking with the PBIX file.

 

I do have a blog post explaining how to change the existing connection details to a dataset in the existing Power BI Service.

 

https://www.fourmoo.com/2017/07/11/power-bi-using-reports-usage-metrics-to-create-custom-reports-lev...

 

Let me know if this works, or if you need some assistance.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

So this is what I did:

 

  1. I created a copy of my original (original.pbix) and had original-copy.pbix
  2. I created a new report (new.pbix) and connected to the dataset via Power BI Service
  3. I renamed new.pbix to new.zip
  4. I renamed original-copy.pbix to original-copy.zip
  5. I extracted new.zip to a folder called new
  6. I copied the connection file in new folder
  7. I pasted the connection file into the original-copy.zip and chose the copy-replace option
  8. I renamed original-copy.zip to original-copy.pbix

When I opened the file, it says the file is corrupt or created in another version of PowerBI

Hi @SandyBL

 

That should work as I had done that in the past.

 

And to confirm that you only copied the "Connection" file.

 

Also do you have the latest version of Power BI Desktop installed?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

I did only copy the connection file and have the latest powerbi.

 

Note that I ended up fixing it by restoring the group/workspace that was accidentally deleted by a collaegue. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors