Reply
PowerBIUser1232
New Member
Partially syndicated - Outbound

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.

PowerBIUser1232_0-1723562288851.png

 

1 ACCEPTED SOLUTION
v-yajiewan-msft
Community Support
Community Support

Syndicated - Outbound

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.

View solution in original post

1 REPLY 1
v-yajiewan-msft
Community Support
Community Support

Syndicated - Outbound

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.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)