Hello,
We’re moving all customers to a GDAP relationship. The question I have is, how do you build Power BI dashboards and reports for a customer with just a GDAP relationship? I can’t find a way to pull in their data through a web service or API because we no longer have that email and password that we would use prior to GDAP. Any help would be appreciated!
Hi Devan,
This is a common question after moving to GDAP. Short answer: GDAP removes passwords, not access. You just need to change how Power BI connects.
What has worked for us in real projects:
Use Entra ID (Azure AD) authentication, not a customer email/password. Your user or service account must have the right GDAP roles.
Pull data from Business Central APIs or OData as usual. Power BI connects using organizational account sign-in under GDAP.
For scheduled refresh, the cleanest setup is a service principal with GDAP permissions. We used this for one customer, and it worked well without relying on personal accounts.
Most issues come from missing GDAP roles, not from GDAP itself. Once permissions are correct, Power BI works the same way as before.
We’ve implemented this setup for customers after moving fully to GDAP. It may need a bit of role tuning, but it is technically and practically supported.