Skip to main content

Notifications

Business Central forum
Suggested answer

how to pull data from the Worksheet(Business central) to Powerbi

Posted on by 72

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?

_2D00_1650557302625.png1650557425480.png_2D00_1650557489458.png

  • Guy McKenzie Profile Picture
    Guy McKenzie 1,330 on at
    RE: how to pull data from the Worksheet(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

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,155 on at
    RE: how to pull data from the Worksheet(Business central) to Powerbi

    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

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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans