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 Community
I am trying to connect to a web api via PBI desktop.
I have been provided with the details of the api, but I am unable to figure out how to translate that into PBI to get my results
below are the details that I need to fetch
GET /0/facebook/profiles
HTTPS Host: api.mywebsite.com
Authorization: Basic wxxXZcCRpbjp5c4V1UqVHgdtwHTF
Content-Type: application/json; charset=utf-8
So far, I am using web connector, in URL I am putting https:\\api.mywebsite.com
then,
in add header I am giving autorization code, and add header content type =application/json
But I am not sure where to provide the first line ie GET /0/facebook/profiles
any help would be highly appriciated. any directions or links to material or any quick hints.
regards
Solved! Go to Solution.
If I am reading that correctly, you need to connect to:
https://api.mywebsite.com/0/facebook/profiles
In other words, you should be getting /0/facebook/profiles from the host api.mywebsites.com.
If I am reading that correctly, you need to connect to:
https://api.mywebsite.com/0/facebook/profiles
In other words, you should be getting /0/facebook/profiles from the host api.mywebsites.com.
Awesome, Thanks.
If I also need to fetch something specific, say I am using following request
Let
Source = Json.Document(Web.Contents("https://api.mywebsite.com/facebook/profiles",
[Headers=[Authorization="Basic TWpjNekV5WHpNNVpEQTBZMlZpWkRJNE9EY3habVU1WdRellqRTE6NDRmMjk1NTM3ZTVhZmENTlmNDg0Nkjdsoifuwenr",
#"Content-Type"="application/json; charset=utf-8"]],
In
Source
OutPUT:
id, name, count, city
if I want to fetch data ony for a specific id, say id number 100 & city = Sydney, how would I ammend the query
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.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |