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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors