- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Ambigious path error in Direct Query dataset, but no such path exists

Good afternoon.
In a .pbix file which connects via Direct Query to another dataset, I'm getting the below error when trying to refresh:
I have simplified the model to try and narrow down the issue to the following (which is still receiving the above error):
As you will be able to see, no ambiguous path exists. One would exist if the relationship between DIM - Jobs and 'FACT - NL Budgets' was active, but it is not.
In an attempt to prove that this file should not be showing this error, I have created a new .pbix file with the exact same DirectQuery link to the dataset, and it refreshes completely fine.
Unfortunately I have quite a large and complex report built within the .pbix file which is showing the error, and I really do not want to have to spend time trying to move this over to a new file.
Can you please assist in investigating why this error is occuring?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- stipa on: Error "[403.12–403.30] The name 'Lakehouse.Content...
- MaAl on: "The import PowerPlatform.Dataflows matches no exp...
-
NikNithiy
on: URGENT!! Paginated Report not loading on Mozilla F...
- duarte on: Unable to sort months in PowerBI
- zsombor on: Matrix Visual doesn't work with Field Parameters ...
-
mattlee on: “Add Value” in Textbox Not Visible in Dark Theme
- mattin on: Report Server Permissions Jan/May 2025
-
bhalicki
on: Bi Crashes on launch with (AS Process PID=XXXXXX H...
- stanteitelbaum on: authenticator wont trigger after purchase of new p...
-
Stinkys
on: Fix the Date function in DAX
- New 8,047
- Needs Info 3,502
- Investigating 3,602
- Accepted 2,088
- Declined 38
- Delivered 3,970
-
Reports
10,246 -
Data Modeling
4,135 -
Dashboards
4,116 -
Gateways
2,116 -
Report Server
2,116 -
APIS and Embedding
1,965 -
Custom Visuals
1,790 -
Content Packs
525 -
Mobile
354 -
Need Help
11 -
Show and Tell
3 -
General Comment
2 -
Tips and Tricks
1 -
Power BI Desktop
1