PowerBI/ Microsoft Project For Web - Query Help

[PowerBIUser1232]

I''ve already connected Microsoft Project for Web to Power BI, what I'm looking for now is the ability to filter based off columns made in the team's Project interface. Is there a query or column I'm missing that would link the columns created to the specific Task or project Overview.

Currently, I only can see the Project Bucket Table which connects to the tasks. 

I just brought in the label table but I can't seem to find a way to link the label table to the Project tasks table.

Asks:

Is there a way to connect Project Tasks table to the Label Table? 

Is there a secondary table that would allow me to filter tasks/Projects based off of columns made in the Team's Project Interface.

[Anonymous · Accepted solution]

Hi @PowerBIUser1232 ,

In Power BI, if there are no directly mapped columns in the task and label tables, we recommend that you find an intermediate table that contains unique values for the task and label tables, such as Task ID and Label ID, and then create the relationship through the intermediate table.

In addition, Microsoft Project for web is out of our scope and we suggest you start a new discussion via the Project Community so that you can get dedicated support on this issue.

Best regards,

Joyce

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