Forum Discussion
One Dataset Many Reports (Powerbi Desktop Can't Be Used?)
I'm pretty sure I understand the problem, as it's something I've had issues with recently.
My specific scenario AS connector to an on-prem SSAS 2012 Tabular model. Create new report in PBI desktop. Publish that report to PBI service.
In service we now see a dataset with the name of the .pbix, and a report with the same name.
In desktop, create a new report in a new .pbix with a different name. Publish that report to PBI service.
In service, we now have two datasets and two reports. The dataset is exactly the same between the two and never could be different, since it's a connection to a single on prem data source. There's no way to share that dataset between reports published from PBI desktop.
Personally, I find the Desktop authoring experience to be much smoother. Additionally, there are some features (one that was an issue when I was doing this work was defining arbitrary hierarchies on axis labels for charts, which could only be authored in PBI desktop) which are only present in Desktop, despite being consumable in the Service.
It's useless, at best, to publish multiple identical datasets. It's confusing for end users and is visual clutter in a content pack or in someone's workspace view.
yes Greg,
Seems to me that PowerBI Desktop it's incomplete, did not follow the Service, and the service does not follow the Desktop, I hope they solve this...
This is basic.