Forum Discussion
How to edit dataset from different report?
HI Anonymous
If I understand your issue, you need to use one dataset in another report. The example report you showed is already developed and published on PBI service.
Assuming it is published on PBI service.
In the new report, I would go to
Try it on the new report, Also, it has a limitation on only one dataset can be attached (atleast it is for me), If you have data flows published, you can try dataflows too.
Anonymous this dataset is coming from an sql server database do i need to enter a valid credentials to access it?(please see the above reply for the pic asking for credetials ), will i be able to model it the same way i do to any normal table? also i am getting the below error
With the get dataset approach, you cannot model it. Because it will alter the dataset which you have pulled.
This dataset is alreqay linked to a report, modeling will change the existing report.
Hope it replies your question.
how about the credientails as it is from an sql server? and why am i getting the below error as below when i opt for the option you advised. how do i solve it?
v-kelly-msftCommunity Support
Hi Anonymous ,
According to your screenshot,it seems that you already have a live connection with another data source in the current .pbix file,if so,pls create a new .pbix file,then choose "dataset" for editting.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!