Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Unable to access OData web services in Power BI

(0) ShareShare
ReportReport
Posted on by 5
  1. Using web service key I am able to use OData web services in Chrome but, In Power BI I am getting Unauthorized response.Kindly help.
  • Steven Renders Profile Picture
    5,500 Moderator on at
    RE: Unable to access OData web services in Power BI

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

    Then, are you using the ODATA connector or the Business Central connector in Power BI Desktop?

    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.

    Then, why are you using the web-service-access-key? Both connectors can use O365 auth.

  • Steven Renders Profile Picture
    5,500 Moderator on at
    RE: Unable to access OData web services in Power BI

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

    Then, are you using the ODATA connector or the Business Central connector in Power BI Desktop?

    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.

    Then, why are you using the web-service-access-key? Both connectors can use O365 auth.

  • Naresh4 Profile Picture
    5 on at
    RE: Unable to access OData web services in Power BI

    I am using BC 17.3 On-Prem

  • Suggested answer
    Steven Renders Profile Picture
    5,500 Moderator on at
    RE: Unable to access OData web services in Power BI

    First, can you explain if you are using BC Saas or OnPrem?

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

    Then, are you using the ODATA connector or the Business Central connector in Power BI Desktop?

    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.

    Then, why are you using the web-service-access-key? Both connectors can use O365 auth.

  • Mohamad Vajid Profile Picture
    on at
    RE: Unable to access OData web services in Power BI

    Can you post the version, and screenshots of your configuration in PowerBI?

  • Suggested answer
    Suresh Kulla Profile Picture
    47,787 on at
    RE: Unable to access OData web services in Power BI

    What version BC are you using?  

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

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

#1
YUN ZHU Profile Picture

YUN ZHU 594 Super User 2025 Season 1

#2
Mansi Soni Profile Picture

Mansi Soni 463

#3
Sagar Dangar, MCP Profile Picture

Sagar Dangar, MCP 391

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans