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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Unable to connect Powe...
Small and medium business | Business Central, N...
Suggested answer

Unable to connect Power BI to Business Central on-prem using basic auth

(0) ShareShare
ReportReport
Posted on by Ibu 25

I am having trouble connecting to our on-prem Business Central OData feeds from Power BI Desktop. Here are the steps I followed:

1) I created a Web Service Access Key token for my own user account in BC

pastedimage1667488031049v1.png

2) I access some OData v4 URL in my browser with my user name & web service access key credentials to confirm it works:

pastedimage1667488423624v2.png

3) In Power BI Desktop, I go to Get Data -> Dynamics 365 Business Central (on-premises) and input the same OData v4 URL as above. It then prompts me for credentials and the same ones do not work:

pastedimage1667488569009v3.png

Same happens when using the standard OData connector.

From another thread on this topic, I am missing two pieces of info that could help in this investigation:

1) "If OnPrem, how are the ODATA web services setup in the Service Tier?"

I don't know what a Service Tier is.

2) Also, you might need to have the Power BI Gateway installed on your server, if your server is behind a firewall and the ports are not open for Power BI to connect to it.

Does Power BI use different ports than the one specified in the URL (7048, which evidently is already opened)? 

Thanks in advance for any help.

Business Central Version: BE Business Central 16.3 (Platform 16.0.14073.14195 + Application 16.3.14238.0)
Power BI Desktop Version: 2.110.805.0 64-bit (October 2022)

I have the same question (0)
  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Unable to connect Power BI to Business Central on-prem using basic auth

    Hello,

    Answers inline.

    1) "If OnPrem, how are the ODATA web services setup in the Service Tier?"

    I don't know what a Service Tier is.

    MSFT: This is the Dynamics 365 Business Central Server also callled Service Tier. You can find the settings that you need to look at either in the customsettings.config file or they are accessible via the Administrative console.

    The requirement here is that a trusted SSL cert is being used and the OData feed must be accessible. You also need to ensure that the OData feed connects over SSL. Relevant keys are:

    ODataServicesPort

    ODataServicesEnabled (true)

    ODataServicesV4EndpointEnabled (true)

    ODataServicesSSLEnabled (true)

    PublicODataBaseUrl

    2) Also, you might need to have the Power BI Gateway installed on your server, if your server is behind a firewall and the ports are not open for Power BI to connect to it.

    There is no need to configure a Power BI Gateway for a simplified scenario.

    Does Power BI use different ports than the one specified in the URL (7048, which evidently is already opened)?

    Thanks in advance for any help.

    Business Central Version: BE Business Central 16.3 (Platform 16.0.14073.14195 + Application 16.3.14238.0)

    Power BI Desktop Version: 2.110.805.0 64-bit (October 2022)

  • Suggested answer
    Ibu Profile Picture
    Ibu 25 on at
    RE: Unable to connect Power BI to Business Central on-prem using basic auth

    Figured it out... I wasn't copy pasting the Web Service Access Key value completely. When copy pasting from Business Central, make sure to triple click the field before doing ctrl+c or it won't capture the '=' character at the end (on Windows anyway).

    Example: if the generated key is "BlaBlaBla=", the UI will show something like "BlaBla..." and double clicking it will select "BlaBlaBla" (but you don't know there's a '=' character it didn't select). If you triple click or inspect the UI using tools, that's when you see the whole string.

  • Ibu Profile Picture
    Ibu 25 on at
    RE: Unable to connect Power BI to Business Central on-prem using basic auth

    Are you referring to the "Set up Business Central on-premises for Power BI integration" section in particular? I got the feeling it's for the use case of viewing Power BI reports from within Business Central. Wrong assumption?

  • Amit Profile Picture
    Amit 2,557 on at
    RE: Unable to connect Power BI to Business Central on-prem using basic auth

    Hi,

    Refer the link

    https://learn.microsoft.com/en-us/dynamics365/business-central/admin-powerbi-setup

    Regards

    Amit Sharma

    www.erpconsultors.com

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

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

#1
Sumit Singh Profile Picture

Sumit Singh 2,710

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 2,675 Super User 2025 Season 2

#3
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 2,203

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans