Announcements
Hello,
I published this page in Business central. When I am trying to pull the data in powerBI getting this error.
I trying to pull the data from the worksheet not from the page in the business central and getting this error.
how can I pull data from the worksheet in business central to PowerBI?
The table is a temporary table so won't hold data in it for Power Bi to extract.
1st question is how time sensitive is your reporting requirement? Power Bi is not live data so if you want a live operational report, you will need to refresh the data manually in Power Bi Desktop. If this is a report you want to dashboard, it won't be up to date. If you want to put it at an end users finger tips with live data, something like Jet may be better.
With regard to building the data set required, you need to calculate the available inventory by item, by location, by date. To do this, you need to gather your inventory data for the BOM components for the location and then all supply and demand up to and including the required date + any reservations that will restrict availability of physical/planned stock. All data must be location specific.
It's perfectly achievable but it's a lot of data to crunch. You need to consider all your supply and demand when calculating the item availability. e.g.
Inventory
Sales order demand
Assembly / Production Component demand
Job Demand
Outbound Transfers
Purchase Return Orders
Purchases
Assembly / Production Output
Inbound Transfers
Sales Return Orders
Reservations
The page in the regular UI relies on an item parameter to calculate the levels. If you want this type of detail in PBI you either need a specific query/page or you use other data sources to formulate the values. I’d think using the assembly BOM data fused with the item table could give you similar results
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156