cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Responsive Resident
Responsive Resident

Duplicate report names when switching to shared dataset --> Impacts for report consumers?

We have a published "Report "A" that uses a dataset embedded in the PBIX file as data source (the common scenario).

 

Because the data in this dataset will be used for other reports as well, we want to change the data source to a shared dataset. The idea is to have a PBIX file with just the dataset and no visuals (let's call it "Master Dataset"). Other reports will visualize the data of that Master Dataset by using the data source "Power BI datasets".

When we create and publish a new "Report A", that uses the Master Dataset as source, we have 2 reports with the same name. The expected behavior was that the existing "Report A" would be replaced. As I read in other posts this seems to be an issue related to the shared dataset.

 

Is it safe to just delete the old report? The report consumers must not be aware that the PBIX file and the underlying dataset have changed. I assume that Power BI uses an internal Report ID and that links the report will be broken. Is there a best practice for this scenario?

 

Thanks a lot for your help!

JJ

 

 

3 REPLIES 3
Highlighted
Responsive Resident
Responsive Resident

Re: Duplicate report names when switching to shared dataset --> Impacts for report consumers?

Does anybody have an advice?

Highlighted
Community Support
Community Support

Re: Duplicate report names when switching to shared dataset --> Impacts for report consumers?

hi @DoubleJ 

If there is a "Report A" in power bi service, you could create another same name report "Report A" in power bi service, because Power BI uses an internal Report ID as primary key. But you could not publish another same name report "Report A" into power bi service in one workspace, it will be replaced.

 

Is it safe to just delete the old report? this is safe, but the report will be lost.

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Responsive Resident
Responsive Resident

Re: Duplicate report names when switching to shared dataset --> Impacts for report consumers?

asdf

Hi @v-lili6-msft. Thanks for your help.

What you describe is what I would have expected: the existing report being replaced be the new one with the same name. But it is not the case. As you can see there are 2 reports named "TestReport". One of them uses the dataset inside the PBIX file, the other one the "SharedDataset" :

 

2020-06-09 11_38_55-Window.png
What I'm wondering is: What impacts do occur when I delete the "TestReport" using the internal dataset.

Would I have to completely rebuild the inital report, deleting all the datasources and replace them by the shared dataset? Would it replace the original report in the Power BI Service or create a new one again?

 

 

Helpful resources

Announcements
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

August Community Highlights

Check out a full recap of the month!

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors
Top Kudoed Authors