hello, thank you for this useful video, but i have problem to analysis the data among the different tables, there are no relations between the tables. as you know to build relation, i have to find common columns between the tables, and this is my issue, i can not find common issue. could you help me to solve this problem? thank you in advance for your reply.
Hi Ahmed, the best advice we can give you is to start learning more about the Primavera P6 database schema. It will tell you how the different tables are connected (by primary and foreign fields) and then you can model them in power BI. This is the link to P6 schema: docs.oracle.com/cd/F25599_01/helpmain.htm?toc.htm?55497.htm
Hi @abdainawi Yeah I know what you mean! P6 database can be a bit complex. The best advice we can give you is that you search for Primavera P6 database schema on google.. it will give you a bit of background on how P6 DB is built up. We will try to upload more videos on the subject too!
Hi Alfred, no it wont work if you refresh it in PBI cloud. This is a connection between your SQL server (local drive) and your Power BI, so PBI Service refreshes wont come thorugh (because it is a connection made in your desktop computer). If you want to refresh it online, you would need to either 1) set up a gateway or 2) configure your P6 in a SQL online (like Azure).
Hello jassy.. thank you very much your explaination is perfect .. ineed to go through doing just one report in power pi from the columns of the data base of p6 located in power pi ..May you guide me ? Regards Ehab
Hi Ehab! You are very kind! Sure, once you get the SQL connection in place, the next thing is to learn about the Primavera P6 database schema, so you can learn how to model (connect) the different tables. The schema will tell you how the different tables are connected (by primary and foreign fields) and then you can model them in power BI. This is the link to P6 schema: docs.oracle.com/cd/F25599_01/helpmain.htm?toc.htm?55497.htm
Hi bro... Were you able find a way to connect to cloud version of Primavera... If so please can you help me with steps or point me to a right direction... I have my Primavera application in Azure cloud and this is very critical to me now in my job... Please help. Also please let me know how I can reach you through email... Thank you.
Hi Shabih, no worries. If you want to connect to a cloud database you would need an API. The API could be provided by the vendor or (if you are a programmer) you could build it yourself using the vendor documentation for APIs.
Hi Blse2000, there many ways to make that type of connection but I recommend you look for your IT department advice. You could create a query (at Database management level) to pull data from the P6 tables in Azure Cloud and to run this query every day or every hour. Then you can bring the query output to power bi by using a Azure Database connection. But as I said, this goes into the realm of IT.
Hola, muy buen video! Estamos atentos al paso 3 para trabajar con esos datos. Saludos,
Hola Marcos! nos lo estan solicitando bastante, asi que nuestro proximo video sera al respecto! quedate atento!
hello, thank you for this useful video, but i have problem to analysis the data among the different tables, there are no relations between the tables.
as you know to build relation, i have to find common columns between the tables, and this is my issue, i can not find common issue.
could you help me to solve this problem?
thank you in advance for your reply.
Hi Ahmed, the best advice we can give you is to start learning more about the Primavera P6 database schema. It will tell you how the different tables are connected (by primary and foreign fields) and then you can model them in power BI. This is the link to P6 schema: docs.oracle.com/cd/F25599_01/helpmain.htm?toc.htm?55497.htm
i have made this sort of connection , but dont know how to create dashboard from this sort of data . could you please help
Hi
@abdainawi
Yeah I know what you mean! P6 database can be a bit complex. The best advice we can give you is that you search for Primavera P6 database schema on google.. it will give you a bit of background on how P6 DB is built up.
We will try to upload more videos on the subject too!
Hola amigo Muy buen trabajo pero podrias Hacer un video con la query, el enlace de las tablas.
Hola Frank, vamos a trabajar un video con ello dentro de poco.
Hello have you tried to publish the PBI and refreshed the data in PBI cloud? I getting an error and not refreshing
Hi Alfred, no it wont work if you refresh it in PBI cloud. This is a connection between your SQL server (local drive) and your Power BI, so PBI Service refreshes wont come thorugh (because it is a connection made in your desktop computer). If you want to refresh it online, you would need to either 1) set up a gateway or 2) configure your P6 in a SQL online (like Azure).
Hello jassy.. thank you very much your explaination is perfect .. ineed to go through doing just one report in power pi from the columns of the data base of p6 located in power pi ..May you guide me ?
Regards
Ehab
Hi Ehab!
You are very kind! Sure, once you get the SQL connection in place, the next thing is to learn about the Primavera P6 database schema, so you can learn how to model (connect) the different tables. The schema will tell you how the different tables are connected (by primary and foreign fields) and then you can model them in power BI. This is the link to P6 schema: docs.oracle.com/cd/F25599_01/helpmain.htm?toc.htm?55497.htm
Details: "ODBC: ERROR [IM014] The specified DSN contains an architecture mismatch between the Driver (64-bit) and Application (32-bit)"
Hi @hadisfitsum6796! This message means that you need to download the Driver 32-bit instead of the 64-bit to make it compatible to your application
Bro, this is local, I was looking for cloud connectivity, if you have any vdo about how to connect to cloud database ping me.
Hi bro... Were you able find a way to connect to cloud version of Primavera... If so please can you help me with steps or point me to a right direction... I have my Primavera application in Azure cloud and this is very critical to me now in my job... Please help. Also please let me know how I can reach you through email... Thank you.
Hi Shabih, no worries. If you want to connect to a cloud database you would need an API. The API could be provided by the vendor or (if you are a programmer) you could build it yourself using the vendor documentation for APIs.
Hi Blse2000, there many ways to make that type of connection but I recommend you look for your IT department advice. You could create a query (at Database management level) to pull data from the P6 tables in Azure Cloud and to run this query every day or every hour. Then you can bring the query output to power bi by using a Azure Database connection. But as I said, this goes into the realm of IT.