Finance | Project Operations, Human Resources, ...

Power Bi Lookup Fields Loading Error

(0) Share

Report

Posted on by Muhammad Saad Rafiq

Hi all,

Working on Power bi Report want to get Report to Position of a worker in order to get the value these entities are required

Worker (mshr)

Position V2 (mshr)

Position Hierarchies (mshr)

when loading these entities error occurred as 400 bad requests when I set the query like this to load only a few columns like

Table.SelectColumns(#"Position V2 (mshr)",{"mshr_hcmpositionv2entityid","mshr_workerpersonnelnumber","mshr_jobid"})

it loaded successfully when I enter the lookup field column in SelectColumns error appears again, is there any restrictions not to load lookup columns I want to load this "mshr_fk_worker_id" column

Thanks,

Muhammad Saad Rafiq.

All responses (3)

Answers (0)

Sort by

Suggested answer

Parag Chapre 12,254 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi Muhammad,

Instead of using this, you can use the below approach from Dataverse tables.

cdm_worker

cdm_jobPosition

cdm_positionworkerassignmentmaps

Try with dataverse connector in Power BI and use above entities.
Muhammad Saad Rafiq 70 on at

Like (0)

Report
Copy link

Link copied!

Hi Parag,

I've tried this approach but we have a scenario where multiple workers assigned to the same job positions i.e. it is possible that several workers can have the same parent job position

Abc is the worker with Job Position 'Jr Software Engineer' and it Reports to XYZ with Job Position 'Senior Software Engineer'

DEF and XYZ both have the same Job Position 'Senior Software Engineer'

in this case, two manager names will appear but the worker reports to which one how can we find it out.

Thanks,

Muhammad Saad Rafiq.
Parag Chapre 12,254 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi Muhammad,

Did you check position hierarchy validation first?

If it is ONE to MANY then it should be possible in Power BI.

I did the same kind of scenarios in Power BI. It works for me. You can message me offline and I will try to help you out.