Forum Discussion
Rest Power BI API - Get information from users, data sources, tables and fields, and so on.
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.
Hi Syndicate_Admin ,
Please follow the steps to create an application.
1. Select the App registrations.
2. Create a new application.
3. Create the application secret and copy the value.
4. Authorize. In API permissions -> Add a permission -> Power BI Service -> Delegated permissions -> select all options -> Grant admin consent for Contoso
5. When the application creation is done, copy the application ID, tenant ID in the overview page.
For privacy settings, you need to set it in the permissions of the data source.
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.
Hello @Syndicate_Admin ,
The application had already created it and now when modifying the permissions, it already allows me to obtain the token, but it still gives me problems:
Formula.Firewall: Query 'Invoked Function' ('Source' step) is gaining access to data sources with privacy levels that cannot be used together. Regenerate this combination of data.
I think the problem is in those functions in which the origin is constructed with the result of a previous function, for example:
https://api.powerbi.com/v1.0/myorg/admin/workspaces/scanStatus/" & PostWorkspaceInfo()
This source does not appear to me in:
So I can't change the level of privacy.
Is there a way to define it in those cases?
On the other hand, I am getting errors in the postWorkspaceInfo step I have realized that if the number of work areas exceeds 100 the function does not work. I need to extract the information from all the work areas of my organization, is there a way to do it?