Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Facing some issues while trying to refresh published datasets on different groups using PowerBI API
Here is what I have done so far:
1. Created a client Id for my application on https://dev.powerbi.com/apps
2. Get call using GET https://api.powerbi.com/v1.0/myorg/groups to get all my listed workspaces along with their group Ids.
3. Passing each group Id at a time to get dataset Ids & names associated with each of the group Ids using GET https://api.powerbi.com/v1.0/myorg/groups/{group_id}/datasets
4. Creating a table object which would store the group Id & its associated dataset id & using this object to pass one item at a time to refresh dataset api i.e. POST https://api.powerbi.com/v1.0/myorg/groups/{group_id}/datasets/{dataset_id}/refreshes
Issues:
1. The refresh POST call does work fine but when I see online on the powerBI portal then the datasets which do not have 'Schedule Refresh = ON' fail to refresh the dataset.
2. Also the POST call works fine on datasets which do not have a gateway defined, but when opening the powerbi portal, it shows that the refresh has failed.
Clarification needed:
1. How is the architecture of these REST API's ? Do they invoke the powerBI gateway service & then refresh the datasets ?
2. Is there a way where we can by pass the issue # 1 mentioned above ?
User | Count |
---|---|
16 | |
11 | |
5 | |
4 | |
3 |