Can i get the public links of all of my workspace reports into PowerBI as a datasource?

[ToolsBI]

So, currently i have the link for the public report copy and pasted into excel so i can have it on a report as data. But i would like to not have to do this if i can avoid. Is it possible to get it in a more automated way? Maybe using the PowerBI API? I am currently trying to use python to extract informations but im not getting anywhere because it seems that the endpoint does not accept GET requests. Im open to suggestions, im hopping that there is a way considering all of this is still Power BI.

[amitchandak]

@ToolsBI , I think Power Bi Cmdlets should help you

https://learn.microsoft.com/en-us/powershell/power-bi/overview?view=powerbi-ps

[ToolsBI]

@amitchandak  Thanks, but now the command Get-PowerBIDashboard is returning empty. Do you know what might be causing this? Other commands like Get-PowerBIReport are working fine.

[3CloudThomas]

Do you have any dashboards created? If yes, then you permissions for the login you used in the API call does not have access. Or, an GUID used to extract is incorrect.

[ToolsBI]

Actually, i dont need that command. Get report gives me something close to what i need, but the links from there are the links or the report in the https://app.powerbi.com/ site, what i need is the public link for the published report, if possible. Is there a way to extract that?

[3CloudThomas]

The only way to have a Public link to a report is to use Publish to Web, which is strongly suggested NOT to do. It exposes your data to the web. You could look at Embed Codes to use an Application (written by you and secured by you) to allow access to reports outside of your network.
Power BI Embedded Analytics | Microsoft Azure

[ToolsBI]

The thing is i will share those reports with people that do not have Power BI accounts, so i need a way that does not require you to have an account or the Power BI itself.

[Brunner_BI]

It does not sound like a good idea but then you need to either to Publish to Web or buy a Power BI Embedded capacity (there you can configure authentication in the background so the clients dont realize)

Generally however, all users need to have at least a free MS account to access stuff.

[ToolsBI]

But is till need to know how to extract the link for the dashboard. I just want the dashboard so people can look at the report and only look.