Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have a little problem with retrieving inf from connected model.
The goal is to retrieve "Operationname" from "mrpoperation" table to "FailregistrationExport" table
By default MRPTable_DAT will be having many antries( Only test file is having many-to-one relation). Test file has one unique orders, but its a straight fact table
If someone will have any idead how to solve it by modeling let me now.
For now i used merge with 2 selections with success
It wont work cause of indicrect relation, many to many . The file i attached has default reliationships with clean power query function
Table work across relationship as production no as id to retrieve Op name for "OperationNo"
FailRegistration>
>MRPtable_dat>
>MRPRoute>
>MRPOperation
After few modification of power query. The table cant display right now the data i m adding from Failregistrtation and MRPoperation
Hi, try to active (x) relation
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |