Dynamic Parameters with Composit Model - Error = DirectQuery Partition - 2 datasource references

[Insights]

Trying to use Dynamic parameters to feed an EXEC query which only works in Import mode; having both modes in the file throws the below error:  "Error DirectQuery Partition... 2 datasource reference(s) in it's expression which is not allowed."

[v-xiaoyan-msft]

Hi @Insights ,

To better reproduce your issue , which version of Power BI Desktop are you currently using?
Also, in our investigation we found that there are people who have similar experience with you in the past, you can refer to their response to see if it helps

Direct Query with Parameter Partition Error - Microsoft Power BI Community

Best regards.
Community Support Team_ Caitlyn

[Insights]

Update - resolved the issue by removing import queries and using all direct-query connections; initially attempted to send the selection to a stored procedure which it did no like.  Changed to using a sql query directly and and that resolved the error.  Thanks

[ganotra_2730]

@Insights  Hey can you plz provide the changes in the query you made I am facing the same issue