web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Connect PowerBI to Customer Instance

(0) ShareShare
ReportReport
Posted on by 45

Hello,

We have multiple Dynamics Business Central customers and I am trying to connect PowerBI Desktop to a specific customers instance.  The customer has added our account as a guest in their Azure Active Directory and has permissioned the account with an External Accountant licenses as well as provided Super permissions within BC.  We are able to login to BC through the web portal as expected.

When we try to connect PowerBI Desktop we go through the Get Data Wizard, and select the Dynamics 365 Business Central connector.  We login using the permissioned account.  However, we do not see the customers instance. 

pastedimage1612456308233v1.png

-

If we try to edit the Data Source settings we receive an error that the instance does not exist.

pastedimage1612456520103v2.png

pastedimage1612456527538v3.png

Questions:

- What is the correct format for the Environment dialog box?  Where do I find that value?

- After we enter the correct environment URL  is the Company required or will all companies be displayed?

- Is there a permission beyond Super that is required to connect with PowerBI?

Thank you,

Matt

I have the same question (0)
  • JAngle Profile Picture
    159 on at

    What authentication type? If it’s basic then you need a web service key. Eventually only oauth will be accepted

  • Brownmattc0 Profile Picture
    45 on at

    Not sure but the login portion proceeds as expected.  The Office 365 login box appears and the login is successful.  The issue is that we do not know how to fill out the Environment dialog box to point PowerBI at the correct Instance.

  • JAngle Profile Picture
    159 on at

    Tenant id is usually followed by “/production” or “/sandbox”

  • Verified answer
    Brownmattc0 Profile Picture
    45 on at

    Apparently the PowerBI desktop client has some issues connecting to other tenants.  Again, we are using an external account (guest Azure AD account) that should be able to connect to the tenant.  However, the PowerBI desktop client will only connect to the tenant of the primary domain.

    We were able to work around this bug by choosing OData as the connection type instead of choosing the built in Dynamics BC connector type.  If you need your OData URL you can find this in the Dynamics Portal by searching for Web Services.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 563 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 374 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 331 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans