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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
RajiSimplogics
New Member

'DirectQuery partition 'Query1-002d8dd6-596e-4e1a-bd7b-e0dcbd1fcf82' has '2' datasource reference(s)

I Tried to create a report using Direct Query to get Bind to Parameters option. In Power Query the query executes perfectly but when i click Apply Changes... im getting the following error:

 

Query1
Failed to save modifications to the server. Error returned: 'DirectQuery partition 'Query1-002d8dd6-596e-4e1a-bd7b-e0dcbd1fcf82' has '2' datasource reference(s) in its expression which is not allowed. '.
 
Its an urgent requiremrnt guys anyone help to fix this issue Please.
2 REPLIES 2
datawailor
Advocate II
Advocate II

I recently had this issue and nothing I tried worked which included deleting the table altogether. what did appear to resolve it for me was recreating the connection to the underlying source. I had yused parameters to get to the table previously so I went the traditional way to connect to the table and that seemed to resolve the issue then I went back the parameterized connection string and that worked too. Not sure deleting the offending table would not resolve it. Hope that helps

lbendlin
Super User
Super User

show a sanitized version of the Power Query code for that data source.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.