Forum Discussion

db1983's avatar
db1983
New Member
2 years ago

Create a web URL as a calculated column, linking to other Power BI reports

Hello,

 

I have a report I have created which shows usage statistics (instead of using the out of the box Power BI stats) - in which we persist the data on to our server so we can see long range trends of usage, rather than just the 2-4 weeks PBI gives you. 

We have a number of workspaces and reports 500+, so was hoping to be able to re-create and then add a link to each report, within this report. 

 

I'm trying to add a new column and concatenate the link using the Workspace ID & Report ID, and have already set the column to be a WEB URL, however when I click and open the link, it says I don't have permission to open the report, even though I know I do. 

 

The new column so far is: 

Link = CONCATENATE(CONCATENATE(CONCATENATE("https://app.powerbi.com/groups/",'Data Capture'[Workspace ID]),"/reports/"),'Data Capture'[ID ]) 
 
The normal web address when I open it, usually has text after the report ID (listed as ID above), however I don't know what this made up of? or if it is actually required to open it/authenticate it? 

/ReportSectionbfd795cd1b134e327277?ctid=fe26127b-78ee-42c7-803e-4d67c0488cf9&openReportSource=ReportInvitation&experience=power-bi

 
Any ideas? 
Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    db1983 ,Based on what I got

    if you have already authenticated then it will not ask for authentication again when click on the URL.

    • db1983's avatar
      db1983
      New Member
      2 years ago

      That's not the issue/or that doesnt work.