In a Direct Query semantic model using Value.NativeQuery for the same server and database (each value stored in a parameter) with calls to views and tables to an on-prem Sql Server will now be treated as separate sources - even if only a single source is used. Opening a DQ model will now show the warning below.
And every table will display with different coloring in Model View - this is new behavior as colors would only change if a different connection, Server or DB was used. This idea is for MS to change back to treating tables on the same connection from the same Server/DB as a single source in the model view with respect to the coloring of the tables. In the past, seeing a different color was a visual indicator that something was not quite right (unless you were truly using a different source). DQ models work best using a single source so the queries are handled at the source and not report side so it's very rare you would want to introduce multiple sources in a DQ model.
Confirmed with MS on a support ticket that this is intended behavior. There is an additional issue, the true bug, where the tables can't be refreshed in Model view. See below comment for the link to that post.
-
Butterfly25
on:
New Button Slicer: Issue with the Grid type of Arr...
- EsmereldaK on: List Slicer Button Dimensions Ignored in Service
-
bhalicki
on:
BUG: report connected to deleted semantic model ca...
- Annamarie on: PBI Semantic Model missing
-
JoshT
on:
Deployment pipelines don't support M365 groups
-
Hongju_Jung
on:
A Typo about Measure tools (Korean)
- jwulffraat on: In the Power BI web version, the left border canno...
- Pig1838 on: DirectQuery not available anymore in Incremental r...
- DataMindedLLC on: 'Refresh Preview' gone from Home Menu Bar in Aug 2...
- qutnd on: Issue with giving Power BI App access to new users