Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Power BI missing custo...
Finance | Project Operations, Human Resources, ...
Answered

Power BI missing custom fields from F&O extension table

(0) ShareShare
ReportReport
Posted on by b_radlyjames 3,081
I have successfully connected to my F&O instance using power BI.  This has been confirmed by creating a simple report and validating the data.
However, I can't see my custom fields (Table extension) in power BI.
 
How can I get my custom fields to show in Power BI?
  • b_radlyjames Profile Picture
    b_radlyjames 3,081 on at
    Power BI missing custom fields from F&O extension table
    Thank you!  I should have caught that earlier... Rookie mistake.  Thanks again!
  • Verified answer
    Anthony Blake Profile Picture
    Anthony Blake 2,199 Super User 2024 Season 2 on at
    Power BI missing custom fields from F&O extension table
    If you are connecting via OData (likely) your custom fields will need to be added to the relevant Data Entities in D365.
  • Suggested answer
    Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    Power BI missing custom fields from F&O extension table
    Hi,
    You can view similar questions and discussions. ( powerbi - Missing data fields from tables in Power BI - Stack Overflow) In Power BI Desktop, use the Data view to preview the data loaded from F&O and check that the data preview is available. If the custom fields do not exist, there may be a problem with the data import process. And whenever changes are made to a table, table extension, or data source, the database needs to be synchronized before the changes can be applied to the environment.How to synchronize the database in D365 - Top Dynamics (d365topdynamics.com)
    Best Regards,
    Hana

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans