Refresh not working in Power bi service when using Merge queries

I have a requirement to get the Azure devops metrics in PowerBI. The data which is required for me is complex, so I have used Merge queries in the Power BI advanced editor which is not causing any dependancy issues when I run the application in Power BI desktop, but when I publish in Power BI web it is causing dependancy issue "references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.. The exception was raised by the IDbCommand interface." How can I overcome it in powerbi web service.