[API rest on premise] power BI report pbix data model

[GwendolineMeta]

hi, 

I am developing a data governance software,

I don't have the problem with Power BI cloud but my problem below is with Power BI on premise

I would like to retrieve the data model of the powerBI report (the pbix report).

I tried "GET /PowerBIReports({Id})/DataModelParameters" but the reponse is empty.

I downloaded the pbix file with REST API but I did not find the REST API to have the data model linked to the report. I tried to uncompress the dataModel included in the pbix file but I did not find the right compression algorithm.

My temporary solution is : Open the report with desktop application and export the model/template (pbit file), with this file I access to uncompressed data model.

But I can automatise this solution.

Do you have a better solution to have the data model of the power BI report with API REST ?

Thank

Gwendoline

[v-jtian-msft]

Hi,@GwendolineMeta .

Has your problem been solved?
If you have found suitable solutions, please share them as it will help more users with similar problems.
Or you can mark the valid suggestions provided by other users as solutions.
Thank you very much for your understanding and support of Power BI.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian

[GwendolineMeta]

Hi,

I will continue to work on finding a good solution when/if I find a solution I will post it here

Have a good day

Gwendoline Franchomme

[Vanchy_Liao]

@GwendolineMeta ,

i am afraid that you can not use this api to get the data model.

there is no documnet describing the actual/effective usages of PBIRS api. the only thing i can find is here.

pbirs | 2.0 | microsoft-rs | SwaggerHub

this swagger is 4 years ago. i can not tell if there is any updated version for PBIRS.

as @lbendlin suggested, you can leaverage .pbip, but PBIRS haven't implemented .pbip yet.

an alternative way is to folk the CLI tool below which can extract data model to json or txt.

pbi-tools CLI | pbi-tools

PBIRS is just inferior to PBI Service from both products and documents perspectives.

[GwendolineMeta · Accepted solution]

Hi,

Finally I found a solution. I recovered a part of the pbi-tool.1.1.1 program. I run MSMDSRV.EXE with the right config file, I recover the port of this service. With this port I create a connection string to connect to a TOM server (Microsoft.AnalysisServices.Tabular). This server allows me to recover datamodel from a pbix file.

[lbendlin]

Read about .PBIP and TMDL and git integration.