Forum Discussion
Community ChampionRepoint Report Created on the Service to another Dataset?
I am trying to solve an issue where a SSAS Tabular Dataset is duplicated (identical copy). Here is the use case
I have a workspace with a dataset connected to a Tabular model (direct query mode).
There are 10 reports published in the workspace with a single dataset.
A user creates a new Desktop file connected to the tabular model with 1 new report
The user publishes the desktop file with the new report and the new dataset (pointing to the same tabular model) to the workgroup. The PBIX has a different name to what was previously published.
Now I have 11 reports in the workgroup. 10 reports go through dataset 1 which connects to tabular. 1 report goes through dataset 2 that points to the same tabular model.
The datasets are now duplicates in every way.
It seems that there is no way to take report number 11 and repoint it to dataset 1, then delete dataset 2.
Can someone confirm? I have checked Ideas but don't see anything that is identical, but I did find this one.
2 Replies
v-sihou-msftMicrosoft Employee
You are correct. On Power BI Service, We can't change the dataset feeding a report, even multiple reports are pointing to same dataset. In your scenario, it's better to get data from Power BI Service directly when creating the report 11 in a new .pbix file.
Regards,
- MattAllington
Thanks Simon. But creating a new PBIX pointing to the original service dataset doesn't solve the problem. When you publish the new PBIX with a new name, the dataset is duplicated regardless.
