What page do I need to use to get resource capacity data into Power BI via a webpage service?

(0) Share

Report

Posted on by Morten Wadstrom

I'm working on a Power BI report that shows a resource "working hour balance". That means if you have worked more hours than you are supposed to, you can save hours for later use. For this I need to set a webpage service that enables Power BI to get data from time sheets and resource capacity.

We had a very early version of Business Central, where it was possible to create a webpage service with resource capacity data. And it worked fine with Power BI, however ,after we have moved our Business Central solution to the latest version, this webpage service does not work any more.

I have looked into the "Resource Capacity" page (213) and the "Resource Capacity Matrix" page 9237. But the "Resource Capacity Matrix" web service returns with data in Power BI as shown below. I was expecting dates and how may hours a resource had as a capacity.

I have tried other "relevant" pages from the complete list i Business Central, but with out any luck!

What to do?

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

JAngle 133 on at

Like (0)

Report

Try page 361. You will need a filter “Period_Start" as it calculates dates with a virtual date table so it’s every date ever

Was this reply helpful? Yes No