Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.