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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
vannavada
Frequent Visitor

Preparing the data model/ Defining Relationships error

We are trying to set up the relations between the different kinds of tables I will be using in generating power bi reports and we are kind of stuck. Below is the relations we are using right now.

vannavada_3-1690477098434.png

When we try to filter the visuals, there are parts where the data retrieved correct but most of the data shown is not corresponding to each other correctly.  like below.

 

vannavada_4-1690477563601.png

This is the whole visual without any interactions applied.

vannavada_5-1690477601173.png

 

I am pretty sure, there needs some changes to the data model level and I am hoping someone here in the community would help me. I am attaching the excel files and pbix file below.

Please help!


I am dropping all the tables down below and pbix file into a drive(it has all .xlsx files too)

BIExamplePbixFile 

AcctMstr

AcctNumNamePhone
123Paul111-1111
456Robert222-2222
789Prashanthi333-3333


RFQHdr

RFQNumberCustAcctDestination
1123England
2456Ireland
3123Germany


ProductMaster

CompPart-SeqDescription
1000-0Wing
1000-1Bolt
2000-0Flange
3000-0Wheel
4000-0Piston
7000-1Whistle
7000-2Tire
7000-3Wiper


Sales

InvoiceInvoiceItemCustAcctCompPart-SeqTNum-SeqQtyShippedPriceCost
111231000-08-02345200
217894000-09-03587210
227892000-010-01678512


Stock

TNum-SeqCompPart-SeqLocationQtyOnHandConditionwhLocation
2-01000-1England50NewZ-92-X
3-02000-0Ireland7NewH-48-4
1-01000-0Memphis2GoodA-48-I9
4-03000-0Memphis8GoodU-33-P0
1-11000-0Memphis1FairB-00-6
5-77000-1France4PoorShop
9-27000-2France6PoorShop
10-47000-3France2PoorShop



RFQItem

RFQNumberRFQItemCompPart-SeqQtyQuotedQtePrice
111000-011000
123000-02500
211000-13250
314000-04375
0 REPLIES 0

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

Top Solution Authors