Forum Discussion

mnegrisoli's avatar
mnegrisoli
Frequent Visitor
7 years ago
Solved

Get report public URL from Rest API

Hi !!! Is it possible to get the public URL embed from specific report by PowerBI Rest API (.NET Microsoft.PowerBI.Api.V2) ?   While get Reports in method GetReportsInGroup, reports have 4 properti...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    HI mnegrisoli ,

    If you mean share url which share with 'publish to web' feature, current REST api is impossible to get that url.

    For embed token, you can refer to following link:

    Embed Token

    Regards,

    Xiaoxin Sheng

mnegrisoli's avatar
mnegrisoli
Frequent Visitor
7 years ago

Thank you Anonymous 

 

It is possible to get a list of all embeded codes from my reports in a workspace (by export via CSV or XLS for example) on Admin Portal or another way ? I have 400 embeded public url´s reports and I need this list.

Cortana's avatar
Cortana
Helper IV
1 year ago

mnegrisoli 

Yes, it's possible. 

By running the following code in python

import msal
import requests
import json

client_id = ""
client_secret = ""
tenant_name = "" 
workspace_id = "" 

authority_url = "https://login.microsoftonline.com/" + tenant_name 
scope = ["https://analysis.windows.net/powerbi/api/.default"]

# Connect the app
app = msal.ConfidentialClientApplication(client_id, authority=authority_url, client_credential=client_secret)
result = app.acquire_token_for_client(scopes=scope)
access_token = result['access_token']

# header
header = {'Content-Type':'application/json',
          'Authorization':f'Bearer {access_token}'}
print("Access token granted")

url = f"https://api.powerbi.com/v1.0/myorg/groups/{workspace_id}/reports"
response = requests.get(url=url, headers=header)

if response.status_code == 200:
    workspace_details = pd.DataFrame(response.json()["value"])
    workspace_details.to_csv('workspace_details.csv')
    print('Workspace detailed captured successfully')
else:
    print(f'Failed to capture workspace details: {response.json()}')

, you will get the details of the given workspaceId.