Forum Discussion
P6 data modelling in powerBI
Hi everyone,
I've successfully connected Power BI directly to Primavera P6. However, I'm facing some challenges with the data modeling part.
I'd like to create a table similar to the one in the screenshot below, with slicers such as Act-Code Name to categorize tasks under each Workstream. I’d also like to include the WBS Name in my Task table.
The issue arises when I try to use Act-Code Name from the ACTVCODE table — it doesn't filter or display the data as expected. This suggests there's a problem with the data model or relationships between the tables.
Could you please advise how I should set up the correct connections between these tables to make it work?
Thank you in advance for your help!
Connect Power BI with SQLite and Primavera P6 | Vahid Doustimajd
Hi EllieY,
Thanks for reaching out to the Microsoft Fabric Forum Community.
Could you please provide a sample PBIX file with mock data. I'd like to validate the relationships between the TASK, TASKACTV, and ACTVCODE tables, especially to troubleshoot an issue where filtering by ACTV_CODE_NAME (Workstream) doesn't affect the visuals as expected.
From the visuals and existing model, everything looks correct the relationships seem to be in place but filtering still isn't working. A working PBIX file would help confirm whether there's a data modeling issue or something else affecting it.
If this helped, please mark the response as the accepted solution and give it a thumbs-up so others can benefit too.
Best regards,
Prasanna Kumar
5 Replies
Hi EllieY,
Thanks for reaching out to the Microsoft Fabric Forum Community.
Could you please provide a sample PBIX file with mock data. I'd like to validate the relationships between the TASK, TASKACTV, and ACTVCODE tables, especially to troubleshoot an issue where filtering by ACTV_CODE_NAME (Workstream) doesn't affect the visuals as expected.
From the visuals and existing model, everything looks correct the relationships seem to be in place but filtering still isn't working. A working PBIX file would help confirm whether there's a data modeling issue or something else affecting it.
If this helped, please mark the response as the accepted solution and give it a thumbs-up so others can benefit too.
Best regards,
Prasanna KumarHi EllieY,
Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.
If the response addressed your query, kindly mark it as Accepted Solution and click Yes if you found it helpful this will benefit others in the community as well.
Best regards,
Prasanna Kumar
Hi EllieY,
We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.
If the issue is resolved, we’d appreciate it if you could mark the helpful reply as Accepted Solution it helps others who might face a similar issue.
Warm regards,
Prasanna Kumar
Hi EllieY,
Just a gentle reminder has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.
This not only closes the loop on your query but also helps others in the community solve similar issues faster.
Thank you for your time and feedback!
Best,
Prasanna Kumar
There are a few free videos under a linkedin group for Power BI and P6 - here is the link:
https://www.linkedin.com/groups/13914226/
Also - Ten Six offers 1-day Power BI class for beginners for P6 users – more details are available at the link below:
https://tensix.com/developing-primavera-p6-reports-with-power-bi-class/
