I want to use one report in different workspace. I want to refresh dataset only ONCE and then use it.
What i have to do? Because right now i found only the one way: publish this report in every workspace.
But this means, that every workspace has it own dataset of this report and i should refresh data many times inspite of one.
Thank you for your comment!
The only workaround I can think of is to publish up a dataset into the Power BI Service.
Then configure this dataset with the refresh frequency that you require.
Then start up a new Power BI Desktop and connect to the Dataset in the Power BI Service.
Then create your report, and then publish it multiple times to each workspace (I know a bit of a pain)
This will mean that all the underlying reports in each workspace will be updated by the one dataset.
A question that I have is why are you publishing the same report to multiple workspaces? Just interested to understand how that works.
I really hope they make this easier in the future. I've been avoiding creating apps until I can figure out a less labor-intensive way to do this than what @GilbertQ suggested.
As for @GilbertQ's question of why someone would want to do this, I can't speak for @dimasikmipt, but I thought it would be nice to create separate apps for the sales teams for each of our business units - that way they could each see our company-wide sales analysis (which would be the report that goes to a bunch of different apps) bundled with their business-specific sales reports.