The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Hi @aJayMitchell
Pease correct me if I wrongly understood your issue .
You connected to other dataset via DQ connection mode in Desktop , then you refreshed you got an error . It happened in the report you created before . But if you recreate a new report via same dataset and connection mode , you can refresh the data normally , right ?
If so , what changes did you make in the original report?
Best Regards,
Community Support Team _ Ailsa Tao