How to force lineage in the PBI Service from a shared semantic model in PBI Desktop?

[swolfe2]

I have created a shared semantic model in the PBI Service.

However, when people connect to that semantic model in DirectQuery, it will create a separate semantic model in the PBI Service that is connected to the shared semantic model:

The preference is that the reports are connected directly to the main shared semantic model with no intermediary semantic models.

Is there a way to accomplish this in PBI Desktop with something like Tabular Editor to force the lineage tags? For functionality, users want to create reports in PBI Desktop rather than the PBI Service.

Any thoughts would be greatly appreciated!

[DataInsights · Accepted solution]

@swolfe2,

According to the Microsoft article below, the semantic model that gets created upon publishing a DirectQuery report contains no data. So, if you create a report that is based on the main semantic model, the report is sourced from the main semantic model even though the report has its own semantic model. Think of the report's semantic model as a pass-through semantic model (no refresh required).

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about 

[swolfe2]

Thanks for that information, @DataInsights. It's just confusing to see a separate semantic model which appears to have all the same settings as the main one within the PBI Service. I was just expecting new Report objects to appear, attached to the same semantic model like when you create a report in the PBI service doing the same thing.

[DataInsights]

@swolfe2,

Yes, it's a bit confusing initially. Reports that use Live Connection don't have their own semantic model, as you've probably noticed.