Formula.Firewall - Error in Power Query ???

[pinarello]

The query "import_oddsportal_and_prepare" runs through on my desktop without error message. The only problem is that the webimport does not always return all rows. Therefore I have to refresh sometimes 2-3 times until all data is delivered. But this is not the problem that is currently the issue.

The problem is that when executing this query on other PCs at the step "web_import" the following error message appears: Formula.Firewall: Query 'import_oddsportal_and_prepare' (step 'web_import') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

I was able to reproduce this on my laptop. But it gets really crazy when I create a new empty folder on my desktop, where the query runs without problems, copy the spreadsheets into it, define the named fields and then copy the queries into it, then this error message also appears on my desktop.

I now have absolutely no idea how to solve the problem.

In the hope that anyone can solve the problem, as an attachment the folder that runs on my desktop without problems.

Here my Excel versions:

Desktop: Microsoft 365, Version 2108, Build 14326.20222, Preview
Laptop: Microsoft 365, Version 2108, Build 14301.20004, Beta channel

 

[pinarello]

Here is the folder I created by copy and paste from the previously uploaded folder and it doesn't work for me either.

Only if I save the folder that works for me under a different name, then it works for me with this copy.

Also the attempt to load all parameters in each case individually as a connection, to add all connections to then perform the webimport, also gives the firewall error.

Here is the information that I created the Power Query because of a request in a German forum. Even though I don't need it for myself, I would like to know what causes the firewall error and how to avoid it.

 

[pinarello]

After a few unsuccessful attempts, I have now managed to create a query that runs on both my desktop and my laptop.

But, as I think, I had to go back to the stone age to do so. Because the websites to import are now determined by formulas in the "import preparation" spreadsheet. This is then imported by the query on it in the step "web_Import" the function "import_websites" applied. Since there is now no reference to previous steps and other queries, the firewall error message is avoided.

So that the query ran then however also without error message on my laptop, I had to deactivate once in the step "web_import", the authorization check. But this will probably be different for each country.

Still very strange is that during the update, the results are often different. Without changing the query settings, the result set of the last refreshes was: 0, 13, 37, 37, 31, 23, 31, 37 rows.

I have no idea if the queried pages are delivering incorrectly, or Power Query is having problems with the import.

Attached is the current workbook.