Forum Discussion

jtrock's avatar
jtrock
Frequent Visitor
4 years ago

Adding a SSAS data model as a data set in a workspace

I am not quite familiar with all of the terminology, so please forgive me if I misrepresent any of the details.   A few years ago, my organization created several departmental workspaces in the Pow...
Need Help
v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi jtrock ,

Thanks for the detailed explanation. I have a doubt, even if Model B is a published dataset, still need to  re-create reports including custom measures, because when you click Transform data>data source setting, choose another dataset, all the visuals are broken, and measures created before are missing.

Best Regards,
Community Support Team _ kalyj

jtrock's avatar
jtrock
Frequent Visitor
4 years ago

That doesn't happen if you have the same Tabular data model as a dataset in different workspaces... you can freely switch between them and the visualizations/measures do not break because all of the same tables/columns/measures are in each data set because you'd be using the same data model.

 

Thank you for your continued help, but I'll just submit a support ticket in to Microsoft to identify this gap.  I find it challenging to believe we're the only one experiencing this roadblock.