topic Re: Questions about reports and datasets in different workspaces in Report Server

Questions about reports and datasets in different workspaces

IHam — Wed, 17 May 2023 14:06:31 GMT

I have two workspaces with some of the same reports in them with the same name, my workspace and an app workspace. If I publish my new report X to my workspace, will it change it for both workspaces? (I appreciate in the app, if its a new graphic, it needs republishing). Will it change in my workspace if publish it to the app first?

What about scheduled refreshes? Will a scheduled refresh in my workspace refresh the same datset in the app workspace? What about the other way around?

Appreciate you expertise on this.

thanks

Re: Questions about reports and datasets in different workspaces

lbendlin — Fri, 19 May 2023 02:30:10 GMT

Reports have nothing to do with this. Datasets in different workspaces refresh independently in import mode. However you can join them / chain them (as composite models) in which case the upstream dataset is treated as a Direct Query source and its meta data participates in the refresh.

Re: Questions about reports and datasets in different workspaces

IHam — Fri, 19 May 2023 07:29:01 GMT

Thanks, so when I publish the report to my workspace and it tells me that this "may impact 2 workspaces, 7 reports and 3 dashboards" this isn't the case and it only impacts the workspace I upload it to?

Re: Questions about reports and datasets in different workspaces

lbendlin — Fri, 19 May 2023 12:15:09 GMT

I mentioned the composite models. Your dataset is used in someone else's dataset as a source. Meta data changes in your dataset will affect them.