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?

All responses (1)

Answers (0)

Suggested answer

JAngle 159 on at

Like (0)

Report
Copy link

Link copied!

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