How to connect to a web service not listed to get data

[anishslabspec]

I would like to connect Power BI to our project management software Procore to get data for analyzing in Power BI

It has APIs - https://www.procore.com/platform/procore-api

How do we connect to it in Power BI?

Thanks

[v-yuezhe-msft · Accepted solution]

@anishslabspec,

Firstly, you can  explore Procore API with Postman following the guide here.

Then you can add a blank query in Power BI Desktop, and then write M code following the guide in this similar blog  in Advanced Editor of this blank query to connect to your data source.

Reference:
https://developers.procore.com/documentation/restful-api-concepts

Regards,
Lydia

[v-yuezhe-msft · Accepted solution]

@anishslabspec,

Firstly, you can  explore Procore API with Postman following the guide here.

Then you can add a blank query in Power BI Desktop, and then write M code following the guide in this similar blog  in Advanced Editor of this blank query to connect to your data source.

Reference:
https://developers.procore.com/documentation/restful-api-concepts

Regards,
Lydia

[anishslabspec · Accepted solution]

Thank you! That works fine.