You’re offline. This is a read only version of the page.
220
Hi BC Guru's,
I'm trying to run a Power BI report to show inventory valuation from Business Central.
Is there a page that will show this without having to run a report?
TIA!
Hi, I agree with Davide, but it's not easy to do. First of all, there are no out of the box pages in the system. If you look at the source code of Inventory Valuation, you can see that its data source is Value Entries. But the logic is very complicated. So I think you can imitate the Inventory Valuation Report to create a new Page, and then select the new Page as the data source from Power BI. This page can be an API page or a page published from Web Service.
Hope this info will help.
Thanks.
ZHU
There is no page that have this value pre calculated that i can think of.
So you can either calculate it directly in Power BI or create a page where it is calculated and use that as your datasource in Power BI.
I would have calculated in in Power BI i think.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,101
Super User 2024 Season 2
#2
Martin Dráb
229,908
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (