- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

PowerBI/ Microsoft Project For Web - Query Help
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
03-26-2024 12:47 AM | |||
09-10-2024 04:28 AM | |||
06-16-2024 05:45 PM | |||
05-13-2024 06:38 PM | |||
06-07-2024 08:08 AM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
48 |