Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

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

(0) ShareShare
ReportReport
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,159 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

News and Announcements

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans