Forum Discussion
Multiple APIs in a single query and/or at one time
I am fine at calling APIs in Power BI. I am getting the expected results. Now I would like to use the API that gives me the list of the users for each APP in Power BI. The API call for this particular one is:
https://api.powerbi.com/v1.0/myorg/admin/apps/{appId}/users
The catch is, I have 90 separate apps - and therefore have to run 90 queries/API calls if there is no way to do a query that gets AppID1 and then AppID2 then AppID3, etc.
I have used an API to get my list of AppID's so I do have a nice table with the 90 AppID's in a column in a query.
And, I have the super long authentication key as well that I can put into the query.
collinq head over to GitHub - migueesc123/PowerBIRESTAPI: A Microsoft Power BI Data Connector or Power Query Connector for the Power BI REST API , grab the code and modify it to include the API calls you need. You can even put in a pull request if you feel that should be included by default.
Note: works with AAD Auth.
2 Replies
collinq head over to GitHub - migueesc123/PowerBIRESTAPI: A Microsoft Power BI Data Connector or Power Query Connector for the Power BI REST API , grab the code and modify it to include the API calls you need. You can even put in a pull request if you feel that should be included by default.
Note: works with AAD Auth.
Did it work out for you? How did you fix it? Can't find the right code.
