Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Steve Bolton]

Hello,

I’m hoping to create some integration between Asana task management tool and Primavera P6 running Web Services, and am running into dead ends.

For access to Asana, I’ve found a connector for Power Automate and Power Apps. However it seems I must have a Task ID already identified before I can make any calls.  Is there a way to query a Workspace to get IDs for related Projects, and then to query a Project ID to get related Tasks?  Having a task list, I could then take action on the specific task ID.

On the P6 side, the Primavera Web Services offers support for SOAP style calls.  However I can’t find a way to connect to it with either PowerApps or Power Automate.  I see only one SOAP connector but it looks like it’s specifically for a different app, and can’t be used for Primavera. Is it possible to make a generic SOAP connection. If so, how do I go about that?

Thanks,
Steve

——————————
Steve Bolton
Sr. Business Analyst
——————————

[Will Page]

You can create a custom connector for SOAP APIs in Logic Apps, so try that.

If you must use power automate, you can develop some middleware in PowerShell to hit the API using the New-WebServiceProxy cmdlet, in a PowerShell Azure function or Azure automation runbook. Call those by HTTP or the Azure Automaton connector respectively.

Here’s a random blog I found about hitting SOAP APIs in PowerShell https://jpearson.blog/2019/04/09/calling-soap-services-from-powershell/

——————————
Will Page
Technical consultant
Christchurch, NZ
——————————
——————————————-

[Steve Bolton]

Thanks Will.  I’ll look into those options.

——————————
Steve Bolton
Sr. Business Analyst
——————————
——————————————-

[Jawad Ali]

Hi Steve,
Actually I haven’t worked with ASANA, tbh 

but I have actually integrated Primavera P6 and Power BI in depth.
Below is the demonstration of the work,
Project Controls using Data Analytics (Primavera P6 and Power BI Integration)

YouTube		remove preview
Project Controls using Data Analytics (Primavera P6 and Power BI Integration) View this on YouTube >

——————————
Jawad Ali
4763
——————————
——————————————-

[Steve Bolton]

Hi Jawad.

Thanks for the link to your YouTube channel.  It looks like you have done a lot of data analytics with P6, but from what I was able to tell it’s all via export to Excel and then read from there into Power BI.

What I’m looking for is to get data using Power Apps or Power Automate via the P6 the Primavera Web Services directly rather than needing an export to Excel first. I then need to use that task info to update related records in an Asana project.

——————————
Steve Bolton
Sr. Business Analyst
——————————
——————————————-

[Jawad Ali]

What if I tell you I never opened excel?? 🙂
i connect P6 data warehouse directly with Power BI. means zero modification in excel u won’t even open excel.
see how it works.

1-You update P6, (press F9)
2-You run reports (I designed them in P6 for structuring and modeling)
3- You press refresh in Power BI.

its that easy 

above all this model is fully automated that it ill adopt any project data automatically

if you need any assistance and help do right me here

reports.pmctool@gmail.com
thanks 

——————————
Jawad Ali
4763
——————————
——————————————-

[Steve Bolton]

Nice enough for that application.  However what I said I was looking for is to get data using Power Apps or Power Automate via the P6 Primavera Web Services directly. That’s the type of connection help I’m looking for. The P6 Web Services uses SOAP protocol. Have you connected using that at all?

——————————
Steve Bolton
Sr. Business Analyst
——————————
——————————————-

[David Kuhl]

Steve,

I was wondering if you ever got an answer with this question?  I’m looking into the same problem now and I’m in the midst of trying to create a custom connector for Power Apps, but I need to figure out how to get the WS-Security layer working with that.  I’m also looking at it from Powershell, using the New-WebServiceProxy cmdlet to create a proxy object.  But when I do that I have trouble actually utilizing the services.  I tried with the Project Service to do a ReadProjects, but I don’t seem able to create the payload properly.  

Anyway, I was wondering how far you got and was hoping you might have a bit of insight.  Thanks!

D.
—

——————————
David Kuhl
Stunt Dummy
——————————
——————————————-

[Paul Ciszewski]

Hi David,

 

Mustang develops many interfaces to P6 via P6 Web Services using .NET/C#.  We considered developing a P6 connector for Power BI for resale.  But after reviewing it, I decided that a connector is not really feasible because of the amount of P6 data that needs to be extracted and the numerous requests to retrieve the data.  Therefore, I decided to develop an extraction software utility that builds a reporting DB for BI reporting – the utility is called P6ETL™.  Once the P6 data is extracted from the P6 DB into the P6ETL™ DB, users can develop BI reports with any report development tool that can connect to a SQL Server DB.  To learn more about P6ETL™, go to http://www.p6etl.com.

 

However – if you just want to connect to the P6 DB (either the native DB or the PX DB) with Power BI, check out this LinkedIn Group: https://www.linkedin.com/groups/13914226/ I created a couple videos in the group to demonstrate how to create Power BI reports for P6.

 

Thank you

Paul Ciszewski

——————————
Paul Ciszewski
Project Manager
——————————
——————————————-

[David Kuhl]

Thanks for that, but I’m more interested in pushing data back to the P6 system.  I’m trying to build a custom connector for that, but I’m getting tripped up on the WS-Security token and nonce that P6 requires.  I’m not sure how to get that into the connector yet.

Cheers,
D.

——————————
David Kuhl
Stunt Dummy
——————————
——————————————-

[Paul Ciszewski]

Mustang Technologies developed an integration to Oracle Hosting/OCI called P6ETL™. P6ETL™ extracts the data from the Primavera P6 database using P6 Web Services and then P6ETL™ creates a reporting database (the P6ETL™ SQL Server database). Then users can connect Power BI to the P6ETL™ database and create Power BI reports. To learn more, go to http://www.p6etl.com

However – if you just want to connect Power BI to the P6 DB, check out this LinkedIn Group: https://www.linkedin.com/groups/13914226/ I created a couple videos in the group to demonstrate how to create Power BI reports for P6.

——————————
Paul Ciszewski
Project Manager
——————————
——————————————-