Authenticating and Connecting Power BI to API

fernando89 — Wed, 16 Aug 2023 09:34:23 GMT

Hi everyone, I'm diving into the world of Power BI now looking to connect it with a CRM we use at work and create live data dashboards from it.

Here's the link for this application (called MYP) API documentation: https://developer.mypcorp.com/art/overview/

For the authentication, I've started following the steps on: https://developer.mypcorp.com/art/authentication/ but in one of the very first steps it asks for an 'Organization URL' to generate keys. Would this be a Power BI generated URL?

If anyone can point me in the right direction and/or to resources where I can refer to to learn the basics of this first stage (getting them connected) it will be great, thanks in advance!

Re: Authenticating and Connecting Power BI to API

Anonymous — Fri, 18 Aug 2023 03:12:04 GMT

Hi @fernando89,

It suppose it may mean the front part of request URL, you can take a look at the following link and sample codes about use web.content to getting data from API with relativepath option:

Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code (crossjoin.co.uk)

let url = "https://developer.mypcorp.com/", body = "{}", token = "xxxxxxxx", header = [ #"Content-Type" = "application/json", #"Authoritation" = "Basic " & token ], response = Web.Contents(url, [ RelativePath = "art/authentication/", Headers = header, Content = Text.ToBinary(body) ]), AccessToken = Json.Document(response)[access_token], JsonResponse = Web.Contents( url, [ RelativePath = "xxx/xxx", Headers = [ Authoraztion = "Basic " & AccessToken, #"Content-Type" = "application/json" ] ] ), Result = Json.Document(JsonResponse) in Result

Regards,

Xiaoxin Sheng

topic Authenticating and Connecting Power BI to API in Developer

Authenticating and Connecting Power BI to API

Re: Authenticating and Connecting Power BI to API