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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Vrykolakas
Frequent Visitor

2 Reports 1 Dataset in the same workspace - publishing report creates a NEW dataset

Hi All,

I'm struggling with this current situation :

- In the same workspace, I have a Dataset "DatasetName" and a Report "ReporName" connected to it. I had to create a second Report "ReporName-Bis" that's also using that one Dataset. 
The issue :

- When publishing/uploading the Report "ReporName-Bis"  into the same workspace, it creates a new Dataset "DatasetName-Bis" , that's pretty redundant since it has the same data/entities as the original dataset.

How can I link the second report to the original dataset and remove the "DatasetName-Bis" one ?
Any Tip is highly welcome 🙂

 

Vrykolakas_0-1692175513068.png

 

4 REPLIES 4
sergej_og
Super User
Super User

ok that works as designed.
now create a copy of your "ReportName", since both datasets has same data and rename the copy.

Not your goal you wanted achieve?

Thank you.

There is a little issue, both reports have the same underlying data, but different pages.. Creating a copy of the "ReportName", and renaming it to "ReportName-Bis",, isnt enough.. I need to readjust the pages everytime on Service.. How do I proceed since publishing the changes from Desktop creates a new dataset  "DatasetName-Bis" 😞 Am I missing something ?

sergej_og
Super User
Super User

Why it is necessary to produce an additional dataset and delete them after creating the report.
Try this approach: Just make a copy of your first Report "ReportName" --> click on ... (the famous 3 dots) right to your existing report.
Since it has the "DatasetName" as Source your new Report "ReportName-Bis" will have the same conncetion to the dataset "DatsetName".
I do the same approach in some cases.

Hope I catched it right.

Regards

Hi @sergej_og , thank you for taking the time to look at my issue.

Deleting the secondly created dataset "DatasetName-Bis" also deleted the "ReportName-Bis" 😞

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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