Power Bi - Reporting Job List Dimensions from each job in Business Central

[stemcin]

Hi there, 

Im new to Power Bi - I'm trying to extract the dimensions attached to all jobs from Business Central. I'm able to extract the list of jobs from the Web Service (legacy) Job_List. However, each job from the job list has dimensions attached to them. I'm unable to see how to extract them - Any advice on this would be much appreciated.

Regards

Stephen

[ReneMoawad]

Hi @stemcin,

You need to get the data of the table DimensionSetEntries under Web Services

In the Transform Data, filter by Dimension_Code based on the dimension that you need (In the below screenshot, we got the dimension Project and another table for the dimension Divisions)

In the Model, create a relation between the Dimension tables and ItemLedgerEntries as below