Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
We have had the pre-built Power BI Log Analytics for Analysis Services Engine app set up for a couple years now, and we just started receiving the following refresh error yesterday afternoon:
We have not done anything custom with this dataset, it should just be the out-of-the-box version. The person who set this up is no longer with our company and I am not super confident with troubleshooting, so hoping someone else has encountered this issue. Let me know if I should submit this as an issue instead.
If you don't have access to edit the PBI report, maybe try looking in your actual data to see if there is a duplicated value for some reason that matches that '418adf73-....' number and see if you can remove it there. Basically this error is because there is a common relationship between that number in one table and the same number in another table. Many to one means that one of the tables has that number listed many times in multiple rows and the other table should only have 1 single row reference to it. When there are duplicates in the single row reference table then it will fail like this.
I honestly don't even know how to locate the data for this report - the source is listed as a web URL beginning with https://api.loganalytics.io/v1/workspaces. I believe something had to be set up via the Azure Portal, but again, the person who set this up is not with the company anymore, and I'm not finding anything that looks right in the Portal. It sounds like I should probably ask our Azure admins to investigate further so we can hopefully locate the data.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!