cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
SandyBL Frequent Visitor
Frequent Visitor

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

Accepted Solutions
SandyBL Frequent Visitor
Frequent Visitor

Re: Point Power BI Service to another dataset

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
Super User
Super User

Re: Point Power BI Service to another dataset

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 Datanaut!"
Power BI Blog
SandyBL Frequent Visitor
Frequent Visitor

Re: Point Power BI Service to another dataset

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

Super User
Super User

Re: Point Power BI Service to another dataset

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 Datanaut!"
Power BI Blog
v-ljerr-msft Super Contributor
Super Contributor

Re: Point Power BI Service to another dataset

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

SandyBL Frequent Visitor
Frequent Visitor

Re: Point Power BI Service to another dataset

That's great

SandyBL Frequent Visitor
Frequent Visitor

Re: Point Power BI Service to another dataset

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

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 279 members 2,951 guests
Please welcome our newest community members: