topic API exploration - How to get model metadata in Report Server

API exploration - How to get model metadata

Anonymous — Fri, 08 Apr 2022 11:33:28 GMT

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

Re: API exploration - How to get model metadata

d_gosbell — Sat, 09 Apr 2022 00:04:36 GMT

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

Re: API exploration - How to get model metadata

Anonymous — Fri, 02 Dec 2022 05:31:54 GMT

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?

Re: API exploration - How to get model metadata

d_gosbell — Fri, 02 Dec 2022 07:25:41 GMT

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