Forum Discussion

EllieY's avatar
EllieY
Regular Visitor
1 year ago
Solved

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 scr...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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