Skip to main content

Notifications

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.

  • 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
    294,208 Super User 2025 Season 1 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
    294,208 Super User 2025 Season 1 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
    294,208 Super User 2025 Season 1 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
    294,208 Super User 2025 Season 1 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
    294,208 Super User 2025 Season 1 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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,208 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,970 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans