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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.