Reuse dataset with SSAS tabular live connection in other workspace

[gijsboelen]

Hi,

I have a report and a dataset in Workspace A and with data coming from an SSAS tabular cube with a live connection. Now I want to copy this report to another Workspace B and switch the data source from the automatically created new dataset to the dataset in Workspace A. Almost all of my options in the Get Data and Transform Data menu are grayed out. In the Transform Data menu, I can only see Data Source Settings, but that only shows the Server and Database name of the tabular cube (because of the live connection).

Can anybody help me find a solution?

Kind regards,

Gijs 

[YukiK]

This type of tool may help separating your dataset and report, which may or may not solve your issue?