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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.