Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now

Insights

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

Submitted by on ‎03-24-2023 01:26 PM

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
See more ideas labeled with:
3 Comments (3 New)
Comments
Anonymous
Not applicable
‎03-26-2023 07:08 PM

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
‎04-20-2023 02:07 PM

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
‎09-12-2023 09:47 PM

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

Idea Statuses