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 Gurus,
Did you happen to know what get data method should I use to get below image. I tried Get Data -> JSON but seems I do not get the drop down option open file as. Any help would be highly appriciated.
Solved! Go to Solution.
Is this a public API? If so, you can provide it and the community can provide the needed M code.
Does the Source step of your query look like this? (check by clicking on Advanced Editor or viewing the Formula Bar in the query editor)
let Source = Json.Document(Web.Contents("http://mywebapi")) in Source
Pasted this from here - https://www.edureka.co/community/26876/how-can-i-connect-my-web-api-with-power-bi-reports
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
If you are trying to connect to a Web API that gives a JSON response, use the Web connector instead. It will recoginize the response as JSON and you navigate/extract your data from there.
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Is this a public API? If so, you can provide it and the community can provide the needed M code.
Does the Source step of your query look like this? (check by clicking on Advanced Editor or viewing the Formula Bar in the query editor)
let Source = Json.Document(Web.Contents("http://mywebapi")) in Source
Pasted this from here - https://www.edureka.co/community/26876/how-can-i-connect-my-web-api-with-power-bi-reports
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |