Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Data modelling problem

Hello, 

 

I have a little problem with retrieving inf from connected model.

lukaszEltwin1_0-1665122676559.png

 

The goal is to retrieve "Operationname" from "mrpoperation" table to "FailregistrationExport" table

test.pbix

 

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

 

3 REPLIES 3
Anonymous
Not applicable

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

Anonymous
Not applicable

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>

lukaszEltwin1_0-1665133546230.png

 

>MRPtable_dat>

lukaszEltwin1_1-1665133705383.png

 

>MRPRoute>

lukaszEltwin1_3-1665133799158.png

 

>MRPOperation

lukaszEltwin1_4-1665133835667.png

 

After few modification of power query. The table cant display right now the data i m adding from Failregistrtation and MRPoperation

lukaszEltwin1_5-1665133933258.png

 

HoangHugo
Solution Specialist
Solution Specialist

Hi, try to active (x) relation

lukaszEltwin1_0-1665122676559.pngrelationship.PNG

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.