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...
Answered

Power BI refresh not working. OData connector

(0) ShareShare
ReportReport
Posted on by

Is anyone else having this issue... seems to have started with the 17.4 update. 

even starting a brand new PowerBI file it still it giving this error also happening on multiple tables

86CB5D4F_2D00_B270_2D00_42B0_2D00_A20B_2D00_97FB4AF4D48A.png

  • Verified answer
    Richard Mayo Profile Picture
    on at
    RE: Power BI refresh not working. OData connector

    Our MS Partner has escalated this with Microsoft and they have confirmed they are aware of the issue. There is a hotfix in production and the estimated ETA is around 4 days.

    Hopefully that will fix it.

  • RustyAustralis Profile Picture
    200 on at
    RE: Power BI refresh not working. OData connector

    I suddenly got the same issue. On 17.4 SaaS with only Essentials license. Interestingly I have data sets using o data directly and those using connector. Only connector fails. The sooner MS allows anyone to submit a request with different SLA response times and have the nominated partner collaborate the better. It will make the service much less fragile. Ongoing issue at the moment. I think it’s something to do with how the connector itself is working. 

  • Steven Renders Profile Picture
    5,500 Moderator on at
    RE: Power BI refresh not working. OData connector

    In Power BI Desktop, options, data source settings, try to clear your credentials and then try to import data again. Does that work?

    And the user you select, which permissions does he/she has in BC?

  • Richard Mayo Profile Picture
    on at
    RE: Power BI refresh not working. OData connector

    No special characters.

    We did recently change to M365 Business Premium to get better security features. Would that have something to do with it? Perhaps my account (which is used for the credentials for the Business Central connector) has some security that’s preventing the connection working properly?!

  • Steven Renders Profile Picture
    5,500 Moderator on at
    RE: Power BI refresh not working. OData connector

    Ok, I understand. Don't worry, the BC connector uses ODATA behind the scene ;-)

    Do you have any special characters in your company name? Like a / or a \ or an ' ?

  • Richard Mayo Profile Picture
    on at
    RE: Power BI refresh not working. OData connector

    That’s the strangest thing, we are using the Business Central connector.... never used OData before

  • Suggested answer
    Steven Renders Profile Picture
    5,500 Moderator on at
    RE: Power BI refresh not working. OData connector

    Strange, here's it's working fine.

    Is there more information in the details?

    Also, why are you using ODATA and not the Power BI Business Central connector?

  • Suggested answer
    Marco Mels Profile Picture
    on at
    RE: Power BI refresh not working. OData connector

    Hello,

    If this issue is happening after an update from Microsoft in the SaaS release, feel free to raise it to Microsoft as an issue via your CSP / Dynamics Partner.

    Thanks.

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 367 Super User 2025 Season 1

#2
Mansi Soni Profile Picture

Mansi Soni 242

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 226 Most Valuable Professional

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans