Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Power BI, Value Entrie...
Small and medium business | Business Central, N...
Suggested answer

Power BI, Value Entries is missing

(0) ShareShare
ReportReport
Posted on by Frida_Admotion 267
Hi! I am new to Power BI and I is trying to do a sales report. I like to use the Value Entries page in Business central, when this page contains all data that I need and also have all amounts in LCY. (We use multiple currencies). There is one options made beforehand to load ValueEntries from Power BI, but that option will not load the customer number, and some other data from the page. Instead I have use the web service link from Page 5802 and used the URL-option which worked fine - I thought. But I now reliased that most of the first year are missing. Some early entries are there, but then it is a leap for several months with no entries. How can this be possible and what can I try to fix this? 
  • Suggested answer
    Steven Renders Profile Picture
    Steven Renders 5,051 Super User 2024 Season 1 on at
    Power BI, Value Entries is missing
    For Power BI it's better to use the APIs instead. they are much faster, and contain more fields. On top if that you can also easily develop your own APIs, based on Queries, so you can aggregate and load a lot faster.
     
    Want to know/learn more?
  • Frida_Admotion Profile Picture
    Frida_Admotion 267 on at
    Power BI, Value Entries is missing
    Hi Zhu!
    The data is in place in BC and even if I use an empty Power BI report I got the same result, so maybe it is your idea of too much data.
     
    Is there a way to filter the data already in BC and just get what I want to get via web service? I just want to get the sales data, not purchases and stock adjustments, so I can easy filter the Value entry list. Or do I need to go by excel to get what I want?
     
    Sorry if this is basics, I just got a crush course in Power BI, but that not covering the Business Central part.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,696 Super User 2024 Season 2 on at
    Power BI, Value Entries is missing
    Hi, generally, the data in Value Entries cannot be deleted by users. I think first you should confirm whether there is such data in the Value Entries in the BC.
    If so, it means there is a problem with the Power BI report, and there may be some filter that affects the data.
     
    Another possibility is that there are too many rows? Odata's processing limit exceeded.
     
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,822 Super User 2024 Season 2 on at
    Power BI, Value Entries is missing
    Does your web services for page 5802 perhaps have some filters applied to it?
     
    In the Web Services Page if you create a new service by using the new action button it simply adds the page with no filters. Have you created this service this way? If not, I would try creating a new one this way and see if it has the missing entries. 
     
     

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans