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.
Hello Everybody
I was looking trough the forum but could not really find threds related to the subsequent challange, which might be caused by the fact that I do not really know how to call my issue.
Situation:
We do use a quality management SaaS solution. They do offer an API which would allow us to get the Data in PowerBI to display the results.
Problem:
In order to receive the desired Checklists with the respective quality control data, they do require a specific Object_ID in the URL:
https://xxxxxx.com/api/v3/assessments?object_id=12345
Therefore I do have to call for each of our 4000 Objects seperatly.
The Number of Objects can fluctuate, but they can also be called over the API, which returns a table (simplified):
ID | Name |
12345 | Object1 |
67890 | Object2 |
Required Solution:
Im therefore looking for a PowerQuery Statement, that loops trough the Object-Table, getting the respective IDs, to call the according checklists.
If you have any hints where to look for respective Input on how this might be done or give me direct Input on a possible solution, you help would be highly appreaciated.
Best Regards
Philippe
Solved! Go to Solution.
If you have a query that calls the API and returns a table of ID/Objects - let's call that query GetObjID then you can get the Checklist for each of those ID'swith this code
Source = List.Transform(GetObjID[ID], each Web.Contents("https://xxxxxx.com/api/v3/assessments?object_id=" & Text.From(_)))
Regards
Phil
Proud to be a Super User!
Please see if this video helps.
(3) Power BI - Tales From The Front - REST APIs - YouTube
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
If you have a query that calls the API and returns a table of ID/Objects - let's call that query GetObjID then you can get the Checklist for each of those ID'swith this code
Source = List.Transform(GetObjID[ID], each Web.Contents("https://xxxxxx.com/api/v3/assessments?object_id=" & Text.From(_)))
Regards
Phil
Proud to be a Super User!
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.