Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
Dear Power BI Community,
I am looking for help with pulling in data from a Rest API. The system is called Appointment-Plus. Here is the API documentation: https://s24400.pcdn.co/wp-content/uploads/2019/04/TechnicalGuide.pdf
So in researching/watching videos I know I need to pull it from the web connector in Power BI. The https link I am using is "https://ws.appointment-plus.com/Appointments/GetAppointments" After that is what I am struggling with. Can anyone help with how to pull in their API?
I am a little out of my depth and don't fully understand how API's work and haven't used one in BI before.
Sorry for the late response, only seen it now.
I don't have an api_key to test but this should get you close (paste it in Advanced Editor as a New Query)
let
api_key= "your_api_key",
fxGetAppointments = () =>
let
base_url = "https://ws.appointment-plus.com/Appointments/GetAppointments",
accessToken = "Bearer " & api_key,
options = [Headers = [Authorization = accessToken, response_type = "json"]],
source = Web.Contents(base_url, options),
jsonList = Json.Document(source)
in
jsonList
in
fxGetAppointments
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 5 | |
| 3 | |
| 3 | |
| 3 | |
| 2 |
| User | Count |
|---|---|
| 7 | |
| 5 | |
| 5 | |
| 5 | |
| 4 |