Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have one api and I need to access the data in power bi. From where I can start.
Details as per below
This is a GET request to an API. You can create a blank query in Power Query Editor, open its Advanced Editor then paste below code into it to replace anything there. Save the code and check whether it can return you the correct result.
let
url = "https://app.celoxis.com/psa/api/v2/tasks/123",
headers = [#"Content-Type" = "application/json", #"Authorization" = "bearer YourTokenHere"],
response = Web.Contents(url, [Headers = headers]),
jsonResponse = Json.Document(response)
in
jsonResponse
For the first time, you need to click "Edit Credentials" and select "Anonymous" type.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.