Recover data that is not push type API Power BI

[Christ-M]

Is there a way to retrieve data that is not of the Push API type. My model is of the Semantic type. I don’t see any clear documentation for this topic and it’s really a challenge for me.

I was able to go to the source of the data, but the problem is that the root data has undergone processing, I just want to recover the processed data. I have thousands of bi-power reports and I need to retrieve data from for each report. Who can give me leads.

These links have not solved my problem.

Semantic model connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft... 

What Is the XMLA Endpoint for Power BI and Why Should I Care? - RADACAD

[v-achippa · Accepted solution]

Hi @Christ-M,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Deku for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[Christ-M]

@Deku Thank you for the links, how to retrieve the data if I do not know the name of the tables. I remind that my data are not push type API. 

GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/tables does not work in my case because it is not a push API

I want to know how to do it before I can look at the DAX queries. 

[Deku]

Only a handful of the APIs are related to push specifically.

You can get the metadata of the entire tenant using the scanner API, including tables if you opt into some of the option flag for extended metadata. Some code that might help

[Deku]

You could script something out with Sempy or Rest API

[Deku]

You can script something out with the Power BI executequery in Group API

Or Semantic Link