Forum Discussion
Advocate IIFormula.Firewall: Query references other queries, so it may not directly access a data source.
Ken Puls blogged about this here
http://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/
The advice provided in this blog post now appears to be running contrary to experience in Power BI.
A query that contains all the Web.Contents calls a query needs leads it to function correctly. The splitting of the different Web.Contents calls into seperate queries before being merged into one final query leads an error to be thrown.
This ^^
you need to bundle all the bits together inside one query, rather than referencing values/tables generated by other queries. BI can't handle you bringing in other queries
For me it was do the following via 2 functions inside the same query (each time you use the API):
- generate token function
- invoke the paged call, using said token
Recycles some code but it works