topic Re: Subscribing Power BI reports through API in Developer

Subscribing Power BI reports through API

shyamganesh — Tue, 22 Oct 2024 08:13:48 GMT

Hi All,

I am trying to do subscribing reports through REST API. But i am not able to do it through API. I knew we can make through Power Automate and in my case i need to do from API end. Is there any solution?

https://learn.microsoft.com/en-us/rest/api/power-bi-report/subscriptions --- these existing api is not working as expected. Anyother ideas?

Re: Subscribing Power BI reports through API

Expiscornovus — Tue, 22 Oct 2024 08:20:51 GMT

Hi @shyamganesh,

When you say, it doesn't work as expected, what do you mean? Are you getting an error code?

If so, can you share a screenshot of your current flow setup that is not working (or explain it in more detail)?

Re: Subscribing Power BI reports through API

shyamganesh — Tue, 22 Oct 2024 08:31:19 GMT

Hi @Expiscornovus

This is code i used for subcribing reports through API

--Code--

import requests
import json

# Define constants
CLIENT_ID = '#######################'
CLIENT_SECRET = '#######################'
TENANT_ID = '#######################'
RESOURCE = 'https://analysis.windows.net/powerbi/api'
API_URL = 'https://api.powerbi.com/v1.0/myorg/groups/{GROUP_ID}/reports/{REPORT_ID}/subscriptions'

def get_access_token():
url = f'https://login.microsoftonline.com/{TENANT_ID}/oauth2/v2.0/token'
headers = {
'Content-Type': 'application/x-www-form-urlencoded'
}
body = {
'grant_type': 'client_credentials',
'client_id': CLIENT_ID,
'client_secret': CLIENT_SECRET,
'scope': RESOURCE + '/.default'
}
response = requests.post(url, headers=headers, data=body)
if response.status_code == 200:
return response.json().get('access_token')
else:
print(f"Failed to obtain access token. Status Code: {response.status_code}, Response: {response.text}")
return None

def create_subscription(access_token, group_id, report_id):
url = API_URL.format(GROUP_ID=group_id, REPORT_ID=report_id)
headers = {
'Authorization': f'Bearer {access_token}',
'Content-Type': 'application/json'
}
data = {
"displayName": "My Subscription",
"schedule": {
"frequency": "Daily",
"timeZone": "Pacific Standard Time",
"times": ["07:00"]
},
"status": "Enabled"
}
response = requests.post(url, headers=headers, json=data)
if response.status_code == 201:
print("Subscription created successfully.")
else:
print(f"Failed to create subscription. Status Code: {response.status_code}, Response: {response.text}")

if __name__ == "__main__":
# Replace with your workspace and report IDs
GROUP_ID = '########################'
REPORT_ID = '#######################'

token = get_access_token()
if token:
create_subscription(token, GROUP_ID, REPORT_ID)

Error

Failed to create subscription. Status Code: 404, Response: {
  "error":{
    "code":"","message":"No HTTP resource was found that matches the request URI}}

Re: Subscribing Power BI reports through API

Expiscornovus — Tue, 22 Oct 2024 09:23:30 GMT

Hi @shyamganesh,

Have you tried the Admin - Reports GetReportSubscriptionsAsAdmin method instead?

https://learn.microsoft.com/en-us/rest/api/power-bi/admin/reports-get-report-subscriptions-as-admin

https://api.powerbi.com/v1.0/myorg/admin/reports/{reportId}/subscriptions

Btw, are you testing in Postman? If not, that is probably easier to test.

Re: Subscribing Power BI reports through API

felaray — Tue, 22 Oct 2024 09:37:02 GMT

@shyamganesh You can't call this api because it does not exist.

ref Solved: How to manage report subscriptions in Power BI clo... - Microsoft Fabric Community

Re: Subscribing Power BI reports through API

shyamganesh — Tue, 22 Oct 2024 09:45:13 GMT

Hi @Expiscornovus

The API you meantioned is not for creating subscription for power bi reports. I am not using postman though

Re: Subscribing Power BI reports through API

shyamganesh — Tue, 22 Oct 2024 09:52:08 GMT

Hi @felaray
Any others ideas apart from power automate?

Re: Subscribing Power BI reports through API

felaray — Tue, 22 Oct 2024 10:13:10 GMT

It is not related to Power Automate, but rather to the Power BI API. I am unable to make calls using Postman because Microsoft has not made the relevant API available.

Re: Subscribing Power BI reports through API

felaray — Tue, 22 Oct 2024 10:15:20 GMT

@Expiscornovus This is a read-only API that can retrieve subscription-related information. Unfortunately, it does not support write operations.

Re: Subscribing Power BI reports through API

Expiscornovus — Tue, 22 Oct 2024 10:25:30 GMT

Hi @shyamganesh,

My bad, I missed that body payload with the schedule. I thought you were collecting/retrieving subscriptions from the existing report on the Power BI Online service.

The link you were referring to in your opening post was a REST API call from Power BI report server (on-premise). Like @felaray already mentioned, that method doesn't exist in the Online APIs.