Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
79 | |
73 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |