Pulling PBI links to database automatically

[mafaber]

Hi,

I'm maintaining a link collection of all our team's PowerBI reports, but it's a pain in the ass to maintain manually.

Can you think of any way to automate this process?

I found an API that can get a list of reports in a workspace, but nothing about the links so far..

https://docs.microsoft.com/en-us/rest/api/power-bi/reports/getreportsingroup

Thank you!

[Seth_C_Bauer]

@mafaber yeah, the APIs work for this. aargh, I was going to blog the quick and dirty solution i used via Postman, but there are some more baked ways I found while researching this using those admin APIs if you want to build an automated report. It does pull back the relevant information, include Web URL. I'll post back to this in the future when I get that blog solution out, but if you need it immediately, Chris Webb did a blog on how to build this as a custom connector, I just didn't have the time to go that route - 

https://blog.crossjoin.co.uk/category/power-bi-api/