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
    v-kkf-msft
    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.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

v-kkf-msft 

Is there a way to add "Date Created" for the artifacts like Reports, Dashboards, Workspaces, Datasets and Dataflows? (admin) tables

 

Questions from my previous post:

1. Can we set dataset schedule refresh if we publish the report created to the service? if yes, can you please help me how ?

2. Can we only scan with Tenant Admin account (Deligated Admin)? (is there a way to use Service Principal (client ID and Secret)

3. Tables inside Experimental folder taking hours and hours to load. "Dataflow Users" table gives "Access Forbidden" error.

 

Thanks in advance.