Forum Discussion
Composite Model - personal vs. shared cloud connection
Hi everyone, I've built a composite model with an import mode part pointing to some on premise data sources, and a direct query part which fetches data from a published semantic model. I understa...
Hi IMett ,
I think that is a designed issue. A shared cloud connection uses credentials from the service. But, a personal cloud uses model owner credentials. They are treated as separate things with separate permissions. So, it will continue to error.
The solution would be to use a Service Account to get around the model owner problem. Or, you could use a live connection instead of a composite. Or, you could import everything (which might not be realistic) into a Lakehouse or a Dataflow and then use that for your report. Or, I think that if you gave every single user the appropriate access to the semantic model that should work (but I think that this might give more permissions than you want).