Get report public URL from Rest API

[mnegrisoli]

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 properties, but no one have he public URL (DataSetId, EmbedUrl, Id, Name and WebUrl)

Thanks, 

[mnegrisoli]

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 properties, but no one have he public URL (DataSetId, EmbedUrl, Id, Name and WebUrl)

Thanks, 

[Anonymous · Accepted solution]

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]

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]

@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. 

[Anonymous]

I'm asking just in a case...

May be is it possible to create a public web link for report via REST API?