Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
JS_UNI4C
Helper I
Helper I

Accessing Business Central API using approved the granular admin relationship

Today one of my clients approved a granular admin relationship so I can now manage their services for them. This is the first time this has happened as previously I had been building dashboards using an account they created for me. As I now start to take on support for clients, they are granting me this privilege. 

 

I can access Business Central this way but my question relates to logging in via Power BI desktop to access Business Central.

 

How would I go about accessing it this way as I am completely stumped or do they still need to give me a normal microsoft licence with associated organisational email to access Business Central via Power BI desktop?

1 ACCEPTED SOLUTION
JS_UNI4C
Helper I
Helper I

Hi, 

 

Thanks for replying but when you are granted granular permissions, this is done through the Microsoft Partner portal and a request is sent to authorise your organisation. When you access their data, you don't access it via an acount so there is nothing to login with. 

 

The customer is going to create an account for me on their side. 

View solution in original post

2 REPLIES 2
JS_UNI4C
Helper I
Helper I

Hi, 

 

Thanks for replying but when you are granted granular permissions, this is done through the Microsoft Partner portal and a request is sent to authorise your organisation. When you access their data, you don't access it via an acount so there is nothing to login with. 

 

The customer is going to create an account for me on their side. 

Anonymous
Not applicable

Hi @JS_UNI4C ,

 

You mentioned that you have access to a customer's Bussiness Central through an account that is approved for a granular administrator relationship.


Have you tried using this account to log into Bussiness Central in Power BI Desktop?

vdengllimsft_0-1726714743165.png

 

Best Regards,

Dengliang Li

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors