Skip to main content

Notifications

Announcements

No record found.

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

Power BI Business Central Connector not showing data

Posted on by

Hi!

I'm looking into an issue for a client.

They have Copied Company A, to create Company B, which they are using as a new business entity. They are now trying to pull data from Company B using Power BI and the built- in Business Central Connector.

Most data is being called fine, however when trying to pull out the Dimensions they're running into issues. In Power Query Editor- the dimension list table shows all available dimensions on both companies, but the dimension entries id coming up blank for company B, except for new dimension values made directly in company B. so, we can definitely see the table data in powerBI, but something is restricting these dimension values that are copied over from showing.

The web services and user permissions are identical on both companies, and the advanced query used to pull the data is also the same.

When I pull the data through an OData v4 url in a web connector, all the data is there.

Does anyone know where else I could look for a discrepancy? I'm currently not sure if it could be an issue with the connector, or just Business Central.

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Power BI Business Central Connector not showing data

    Hello,

    Probably best is raise this question to your partner who may need to contact Microsoft.

    Thank you.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans