Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Rest Power BI API - Get information from users, data sources, tables and fields, and so on.

Hi, I'm trying to query the Power BI REST API information to make a report with it. The intention is to be able to consult each workspace: reports, datasets, users and dashboards. I have managed...
  • v-kkf-msft's avatar
    4 years ago

    Hi Syndicate_Admin ,

     

    I find the Power BI API (Beta) custom connector that you can use to call the Power BI Rest API without writing code.

     

    a) Get the .mez file from this link: https://github.com/migueesc123/PowerBIRESTAPI/raw/master/Power%20BI%20API.mez

     

    b) Place the connector. mez file in the [Documents]\Power BI Desktop\Custom Connectors folder. If this folder does not exist, create it.

    In my example, the full path is “C:\Users\Administrator\Documents\Power BI Desktop\Custom Connectors folder”.

     

     

    c) In Power BI Desktop, select File > Options and settings > Options > Security. Under Data Extensions, select (Not Recommended) Allow any extension to load without validation or warning. Click OK, and restart Power BI Desktop.

     

     

    d) Launch Power BI Desktop and find the Power BI API (Beta) connector.

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.