10 Comments

  1. Kade Soprano
    24 September, 2021 @ 17:09

    How can you connect Power BI to P6 if the P6 database is cloud connect, which is the database in my P6 installation?

    Reply

    • Project 2080
      3 October, 2021 @ 20:25

      Hi Kade,

      thanks for your comment. We recommend you contacting Oracle to find out the best way to connect this database to Power BI. In the meantime, we will try to find out more about it. We are so sorry for not being able to help you this time.

      Regards,

      Reply

  2. Rogerio Valle
    14 January, 2022 @ 16:46

    Sir,
    Do you have by any chance documentation regarding Primavera p6 database tables and their fields in order to create
    a project S-Curve?

    I appreciated.

    Regards,

    Reply

    • Project 2080
      17 January, 2022 @ 09:39

      Hi Rogerio,

      thanks for your message. I am currently working on a new post where I show how to connect XER files to POWER BI, using the tables within the XER file. As part of this new post, i will include for free a Power BI file with all these P6 tables and data transformation. You will have only to download your XER file and magic will be automatically shown.

      Regards,

      Reply

    • Erik Jonker
      29 April, 2022 @ 21:31

      Reply

  3. Rogerio Valle
    14 January, 2022 @ 16:47

    Sir,
    Do you have by any chance documentation regarding Primavera p6 database tables and their fields in order to create
    a project S-Curve in Power BI, I mean.

    I appreciated.

    Regards,

    Reply

    • Project 2080
      17 January, 2022 @ 10:02

      Dear Rogerio,

      thanks for your message. As we informed you in a previous message, we are working on a new post where we explain how to connect the XER file to Power BI. On it, you will find how we create S-Curves in Power BI.

      In the meantime, to create an S-Curve in Power BI you can use the following formula:

      Physical Progress to date =
      CALCULATE (
      [Physical Progress to date],
      FILTER (
      ALL(‘Data Set’),
      ‘Data Set'[Finish Date]<=TODAY() ) ) where [Physical Progress to date] is a measure in Power BI and equals to "Physical Progress to date = SUM ('Data Set' [Physical Progress])". If you want to be the first one to receive new content and be actively part of our community, you can subscribe for free.

      Regards,

      Regards,

      Reply

  4. Khaled
    6 May, 2022 @ 09:38

    I followed Step 1 and 2 in your post. But I can not find “SQLite3 ODBC Driver” option in the list as per Step 3. What to do?

    Reply

    • Project 2080
      6 May, 2022 @ 12:00

      Hi, Khaled

      Thanks for your message. Please, select “SQLite ODBC Driver” instead. It is weird you are not able to see the “SQLite3 ODBC Driver” option. Did you install the Primavera P6 database as “P6 Pro Standalone (SQLite)”?

      Regards,

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *