Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

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."

 

Manage_Parameters_Error.PNGManage_Parameters_Error2.PNG

Status: Investigating

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

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

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
Frequent Visitor

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
Frequent Visitor

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