Dynamic data source for planners

[Anonymous]

Hello,

I want to retrieve data from Microsoft planner on PowerBI via APIs. I am currently using the following query :

https://graph.microsoft.com/v1.0/planner/plans/{plan ID}/tasks

The problem is that I would like to retrieve data from several planners (who are all in the same Sharepoint team) but instead of creating a new request for each new planner, I would like it to be automated...

I succeeded to retrieve the ID of all my planners with the following query:

https://graph.microsoft.com/v1.0/groups/{group ID}/planner/plans  :

Now what I would like to do is that in my first query, the {plan ID} would fetch the values ​​of value.id from my second query.

I think I'm close to finding the solution but I'm stuck. Here are the steps I did :

• Add value.id as a new query

• Creating a Parameter :

• Editing my 1st query to include the parameter: Json.Document(Web.Contents(https://graph.microsoft.com/v1.0/planner/plans/ & Paramètre1 & "/tasks"))

If in my parameter I change the current value to put an ID of a plan, my query works well but gives me only the tasks of the plan that I have entered but not the others…

How to automatically retrieve data from all planners?

Thank you for your response and have a good day.

[Anonymous · Accepted solution]

Hi @Anonymous,

Thank you for your answer, but I've found an other solution :

• I started by transforming my first query into a function :

• And on my second query, I add a column that calls the function
  
• I get what I wanted (Tasks by plan) :

[Anonymous]

Hi @Anonymous ,

You may mean use parameters to automatically change the data sources.

To my knowledge, currently parameters could only dynamically change data sources by choosing different value for"Current Value" as you mentioned.

I doubt you need an extra script (may be Power Automate or something). 

Refer to:

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Docs

Change the Source of Power BI Datasets Dynamically Using Power Query Parameters - RADACAD

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.