API, Power BI and JSON

[Anonymous]

Hi All,

I'm hoping someone can help.  I use Power BI on a daily basis and all my reporting is done via SQL scripts directly into Power BI.  My origanistion has just started using a new sales platform which does not sit on SQL.   They use an API which aapprently we can access and pull directly into Power BI.  Has anyone had any expericne with this?  I have never used an API before and have no idea if this is something i can do? I'm trying to understand if it is as easy as just connecting to the API and building the reports as normal in Power BI.  Will this be a live source and how do you select what tables, columns ect you need?

Many thanks

Craig

[blopez11]

There is quite a bit of material on the internet related to this topic

We have implemented quite a few reports using RESTful web service APIs

However, they can be quite tricky when it comes to authentication, pagination, etc.

It really comes down to the API you are accessing

We typically play with the API using Postman to make sure we can get the queries to work before moving to Power BI

Good luck,