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 :
Finance | Project Operations, Human Resources, ...
Unanswered

Get "This table is empty" when connecting power bi to d365 via ODATA

(0) ShareShare
ReportReport
Posted on by

3125.Capture.PNG
Hi all..
Although that the invent table is full with data i get "This table is empty" message when i try to connect power bi to the entity 
so any help please.

I have the same question (0)
  • 365 financial Profile Picture
    on at
    RE: Get "This table is empty" when connecting power bi to d365 via ODATA

    ok Andre I will check this failure of sync. thank u for your response..

  • André Arnaud de Calavon Profile Picture
    297,421 Super User 2025 Season 2 on at
    RE: Get "This table is empty" when connecting power bi to d365 via ODATA

    If the database synchronization failed, you must check the error and resolve this. This would be most likely the cause that there are no records visible now.

  • 365 financial Profile Picture
    on at
    RE: Get "This table is empty" when connecting power bi to d365 via ODATA

    yes it is moved to a UAT environment

    the database synchronization failed

  • André Arnaud de Calavon Profile Picture
    297,421 Super User 2025 Season 2 on at
    RE: Get "This table is empty" when connecting power bi to d365 via ODATA

    Hi 365 financial,

    Did you move entity to a UAT environment or another development environment? Is the database synchronization completed with success?

    When you export data from this entity using the Data Management framework, can you then see records?

  • 365 financial Profile Picture
    on at
    RE: Get "This table is empty" when connecting power bi to d365 via ODATA

    Hi Andre

    sorry for late replay  , icorrect the url in the previous replay and es the table is full with data when i browse it with the company 'MM' but when try in power bi there is no data

  • André Arnaud de Calavon Profile Picture
    297,421 Super User 2025 Season 2 on at
    RE: Get "This table is empty" when connecting power bi to d365 via ODATA

    Hi 365 financial,

    You haven't answered my questions, so I still don't know if there are records in the table or if the default company from the user is different from the company. Note that the URL you shared isn't fully visible.

    Have you used the option which is described in the documentation: Open Data Protocol (OData) - filter by a particular company that isn't your default company

  • 365 financial Profile Picture
    on at
    RE: Get "This table is empty" when connecting power bi to d365 via ODATA

    i add the cmp parameter to the url like this "myUrl.com/data/?cmp='mm' but the problem is still

  • André Arnaud de Calavon Profile Picture
    297,421 Super User 2025 Season 2 on at
    RE: Get "This table is empty" when connecting power bi to d365 via ODATA

    I would suggest checking if the underlying tables do actually have data. What is the default company for the user? By default the F&O OData connection shows records from the default company unless you set a parameter to retrieve data cross-company.

  • 365 financial Profile Picture
    on at
    RE: Get "This table is empty" when connecting power bi to d365 via ODATA

    Yes it is a customized entity in my environment and i was able to read the data but when i exported it to another environment and try to connect powerbi the message is shown !

    "This table is empty"

  • André Arnaud de Calavon Profile Picture
    297,421 Super User 2025 Season 2 on at
    RE: Get "This table is empty" when connecting power bi to d365 via ODATA

    Hi 365 financial,

    I'm not able to find the entity based on the public name "InventDatas". Is this a customization in your environment?

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

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…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 777 User Group Leader

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 630 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 602 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans