How to workaround [Unable to combine data] error when using Web and Sharepoint sources in a report

Hello everyone

I've spent quite some time searching the solution on the Internet and trying different workarounds but no luck so far.

Here is my scenario:
- I have a list of test case ids stored in a csv file in sharepoint
- Using these ids I want to get the information about test cases from azure devops
- In my report I read all test case ids using SharePoint Folder connector in Power BI and store them as a list in PBI
- Then I use Table.FromList() to convert the list to a table
- After that I need to add a column to this table with information about each test case retrieved from azure devops via api. The column should contain the date when a specific test case field was set to a certain value. So I use _apis/wit/workItems/<test_case_id>/updates request (Web.Contents() function). And I need to execute this request for each id

Needless to say that in PBI Desktop my report is refreshed successfully. There I set Privacy Levels to Always ignore Privacy Level settings. But as soon as I publish the report to PBI Service and try to refresh it there, the refresh fails with classic '[Unable to combine data] <step_name> 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 IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: <table_name>' error.
Data sources have same privacy levels (Public) set in dataset setting in PBI Service.

I've tried solutions suggested in Chris Webb's BI Blog (many people reference this blog), but for some reason suggested there solutions didn't work for me.

Are there any other ideas on how to workaround this issue in my particular case? Or maybe some ideas on how to approach my task in some other way.

Thank you in advance