Forum Discussion
Question about Direct Query with shared semantic models
Hello,
Currently I mange shared semantic models for various business departments that feed mainly from a common data warehouse. These shared semantic models use Import storage mode. One department would now like to add some excel data (that they would maintain) to one of their reports. If this report is changed to use a composite model then the connection to the shared PBI semantic model will change to Direct Query.
Does this mean that just the shared semantic model will be accessed directly, or will the shared semantic model also then access the DWH via DQ instead of Import.
Cheers,
R
When you create a composite model that connects to your shared semantic model via DirectQuery and adds Excel data, only the connection between your report and the shared semantic model will be DirectQuery.
The shared semantic model itself will maintain its original Import storage mode connection to the data warehouse.
In other words:
Your report will use DirectQuery to access the shared semantic model
The shared semantic model will continue to use Import mode to access the data warehouse
Your Excel data will be imported into your report
This is what's known as "chaining" in composite models, where a DirectQuery connection is made to another tabular model (in this case, your shared semantic model). The underlying storage mode of the shared semantic model remains unchanged
8 Replies
in the composite model you can see which tables are direct query or imported in the layout view (model view). if your dwh tables are set to import, then they will still need to be imported in. Not sure if i am answering your question.
When you create a composite model that connects to your shared semantic model via DirectQuery and adds Excel data, only the connection between your report and the shared semantic model will be DirectQuery.
The shared semantic model itself will maintain its original Import storage mode connection to the data warehouse.
In other words:
Your report will use DirectQuery to access the shared semantic model
The shared semantic model will continue to use Import mode to access the data warehouse
Your Excel data will be imported into your report
This is what's known as "chaining" in composite models, where a DirectQuery connection is made to another tabular model (in this case, your shared semantic model). The underlying storage mode of the shared semantic model remains unchanged
Hello,
Currently I mange shared semantic models for various business departments that feed mainly from a common data warehouse. These shared semantic models use Import storage mode. One department would now like to add some excel data (that they would maintain) to one of their reports. If this report is changed to use a composite model then the connection to the shared PBI semantic model will change to Direct Query.
Does this mean that just the shared semantic model will be accessed directly, or will the shared semantic model also then access the DWH via DQ instead of Import.
Cheers,
R
