Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Graph api, keep getting "Access to the resource is forbidden"

How can I use the Graph API in powerbi using user credentials. I am able to use an registered app and adding the client secret but I don't want to do this.  This needs to work with shceduled refresh...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks Anonymous 

 

As I already have the the approach of an application in Azure AD, assign the necessary Microsoft Graph API permissions (such as User.Read.All), and authenticate using an App ID with the client secret what I need to solve then as you and tharunkumarRTK  suggest is to sue Azure Key Vault. 

You mention:

"To avoid hardcoding secrets, you can store credentials securely in Azure Key Vault and reference them in Power BI Dataflows, which offers a cleaner and more secure setup"

I'm not sure how to do this, I'm using powerbi M to code this and not sure how to get the credential from vault secret. Any example I can follow?

 

Thanks Ahead of time...

Anonymous's avatar
Anonymous
Not applicable
1 year ago

HI Anonymous ,
Thanks for the follow-up.
You can refer to the following links for guidance on configuring Azure Key Vault for use within the Power BI Service:
Bring your own encryption keys for Power BI - Power BI | Microsoft Learn

How to access Azure KeyVault from Power BI Query t... - Microsoft Fabric Community

Re: How to access Azure KeyVault from Power BI Que... - Microsoft Fabric Community

 

Hope this helps. Please reach out for further assistance.
Please consider marking the helpful reply as Accepted Solution and giving kudos to assist others with similar issues.