Forum Discussion
Sharing report with Composite Model does not work
I have a Composite Model which is connected in "Direct Query for AS" mode with 2 Semantic Models (which contains "normal" imported tables).
When sharing the report connected with this model, the users can open the report but every visual in the report shows an error:
A connection could not be made to the data source with the Name of '{"protocol":"analysis-services","address":{"server":"powerbi://api.powerbi.com/v1.0/myorg/TEST%20Composite%20Model","database":"LEVEL 1 - Importmodell A"},"authentication":null,"query":null}'.
It is all the same when using the "Share" function, the "App" function or the "Viewer" role on the workspace (with or without the Build permission) in order to share the report.
The connection with the underlying semantic models works for users with the "Contributor" role on the workspace or higher, therefore the connection to the semantic models works.
Thank you for your help!
The problem could be solved now. It seems that the problem with the sharing was caused due to the fact, that all Measures (in all involved Semantic Models) were located in a Calculated Table called "[ Measures]". As soon as I created the first measure in an "normal" import table, the sharing started working. This was true even after I moved the new measure to the "[ Measures]" table.
Best Regards
Robert
11 Replies
Your users must "install" all the apps of the participating semantic models. (ie click on each app link once)
Thank you! But all 3 Semantic Models (2 Import + 1 Composite) are on the same workspace and also part of the same App ... so my users have access to all 3 Models. The 2 Imported Models can be accessed without problems, the visuals in the report of the 1 Composite Model show all the error mentioned above ...
