Firstly, apologies if posted in wrong forum. First time here so happy to be redirected if needed :)
I have been asked to create a way for users to see Power BI reports, they have access to, within SharePoint, via clickable links.
I can create the links manually, however, I would like to have Power Automate query Power BI service and have a json file returned which I can parse and use to update the links automatically.
I have tested using a token generated on my own account, understand this is not good practise, and want to have a Power Automate app, created in Azure Apps, handle the access for the query.
Is this possible? If yes, does anyone know of a solid guide on how to correctly configure as I keep getting permissions errors, despite doing the following:
1) Adding the required permissions to the app
2) Enabling 'Service Principles can access read-only admin APIs' within Power BI service.
My automate does use the app secret etc to successfully obtain a token but when I attempt to use this to query the api at PowerBI.com I get 'ServicePrincipalIsNotAllowedByTenantAdminSwitch'.
Thanks