Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello,
On Report Server, i noticed using F12 Developer options that i could see something similar to report Layout (whem pbix decompressed) if i see the following link :
https://server/powerbi/api/explore/reports/{report id}/modelsAndExploration?preferReadOnlySession=true
My question is if there is an API GET (or POST method) where i can retrieve the metadata of model - Example : measures code, partitions, power query code, with the objective to build an automatic model documentation solution.
What i would look is something like :
https://server/powerbi/api/explore/reports/{report id}/measures or https://server/powerbi/api/explore/reports/{report id}/datamodel
Thanks
Rui
Solved! Go to Solution.
The full public, documented API is published here https://app.swaggerhub.com/apis/microsoft-rs/pbirs/2.0# and there are no methods in there that return the model metadata. Although you will not find the modelsAndExploration endpoint in there either as this must be an internal, undocumented endpoint.
However becuase PBIRS does not offer a web editing experience I do not believe you will even find an undocumented API to get the model metadata
How can I obtain token for these APIs? Im unable to access these APIs because of the tokens. Could anyone tell me something regarding this?
@Anonymous wrote:
How can I obtain token for these APIs? Im unable to access these APIs because of the tokens. Could anyone tell me something regarding this?
The on-prem report server does not require or support the use of tokens for authentication. They use NTLM/Kerberos auth by default.
Just doing a quick google for "Power BI REST API authentication" turned up the following which may help
https://community.powerbi.com/t5/Developer/REST-API-Get-Access-Token/m-p/1895937
The full public, documented API is published here https://app.swaggerhub.com/apis/microsoft-rs/pbirs/2.0# and there are no methods in there that return the model metadata. Although you will not find the modelsAndExploration endpoint in there either as this must be an internal, undocumented endpoint.
However becuase PBIRS does not offer a web editing experience I do not believe you will even find an undocumented API to get the model metadata