Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need some help with API call Power BI

so i have an API link to get data, it requires simply a post command with the api link and some body information   the body info is as followed:     This works fine in Postman and I get th...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  Anonymous ,

You can refer the following links to connect API in Power BI Desktop by web connector:

How do I connect to REST APIs with Power BI? (Part 1)

Chris Webb's BI Blog: Working with Web Services in Power Query

Web.Contents(
  "https://www.regonline.com/api/default.asmx/GetEvents",
  [
   Query=[ #"filter"="", #"orderBy"=""],
   Headers=[#"APIToken" = "insertAPITokenHere"]
  ])

Read API Data with Power BI using Power Query

 

And about how to get access token, you can refer the following video to get it.

Building a Power BI Admin View [Part 2]: Obtaining a Refreshable Access Token

Get access token

Best Regards