Forum Discussion
Sharing Date Table for multiple semantic models in multiple Workspaces (and reports fail)
I have two opposing opinions on that
1. That's how composite models work. Same with Premium where all users need to "install" all apps from the participating semantic models. You can choose to "auto install" apps to avoid that.
2. The Date table is very small and there is no problem to reference it multiple times. You could even import a master date table that controls all the other date tables. When you have composite models you need to watch out for links with key column cardinality over 50K,
lbendlin Thanks.
Do you mean/ think sharing an "App" instead of "Report" may solve the problem or do I still need to grant permission to each consumer in each "upper level data set" of those composite models?
The Date Table is merely a DAX created simple table (Date, FY, FQ, sorting order, that's it) and saved separately in a dataset called "Date Table". Currently it seems to be linked to each composite models by "direct query". Do you think I can link them by import?
Thanks again.
Yes to both. But if you are a small company then Premium may not be for you.