Forum Discussion
Solved
Dynamically query multiple OData Feeds
I am trying to create a master view of all tasks assigned to multiple Microsoft Planner Plans in a single Group. This is possible using the Microsoft 365 Graph, but I want it to dynamically add addit...
you can create a function in M that takes the PlanId as a parameter and does the fetching. or just concatenate the string.
Table.AddColumn("x","y", each OData.Feed(urla & [PlanId] & urlb) )
etc.
I tried this and I get the error "We encountered an error while trying to connect.
Details: "Query 'Query2' (step 'Source') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination."
The only difference in my setup vs yours is the Managed Parameter is a Query of the m code in the first screenshot.