Forum Discussion
Calling PowerBI Rest API in Power Query
One other remark, be careful about copy and paste with the "". For whatever reason, these will occasionally be slightly different quotation marks that won't be recognized as strings within the editor. I have seen it happen with other programming languages, but just figured I would remind you as it got me once already...
Thanks much for the info bflury. Yes, each API is called differently. Microsoft's documentation here on using the PowerBI API seems so simple: https://docs.microsoft.com/en-us/rest/api/power-bi/apps/getapps . My problem is how to translate that to M code and use in Power Query.
Helo and thank you for your message, this is exactly the situation i am into. Any news from then?
I want to access de PowerBi REST API, into PowerQuery in order to load in a PowerBi Report the date of last update of the list of reports i'm giving access to...
I was looking at Json.document(Web.Content()) a bit like in the following post:
https://www.mssqltips.com/sqlservertip/6318/read-api-data-with-power-bi-using-power-query/
But it requieres a Token, and without the Token it gives a message error or credencial issues
