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.
Dear experts,
I am facing a strange issue.
I have 2 excel files as sources.
- the first one is a the transaction data of sales data. One of the fields (StellinID) is the location of the goods, on 8 characters as a text field
- the second one is the master data of that location (key and description) : the key is a text field, 8 characters long...
When I create the relation 1:N in the relationship manager, it does not complain. But, when trying to get the transaction data by the description of the Stelling (like Sales per stelling name), the relation does not work. It can not find the corresponding values between the tables...
I checked the duplicates, I checked, the lenght, the type...
Any idea where it could come from ?
Thanks
PY
Solved! Go to Solution.
Hi @Anonymous ,
1. You relationship netween the tables "Sales by Day" and "Stelling_Master_data" on column "StellinID" is perfectly right.
2. In you .pbix file on "Page1" tab, 3rd table on the right, you have moved Stellin Id from both the tables but you get blank data for StellinID from "Stelling_Master_data" against the StellinIDs coming from "Sales by Day". The reason for this is, these StellinIds don't exist in your "Stelling_Master_data".
Unique StellinId count in "Stelling_Master_data" = 136
Unique StellinId count in "Sales by Day" = 16
There exist no common "StellinIds" in these two tables.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Hi @Anonymous ,
Could you please show some screenshots of your data, data model, and relationship?
if you can share a pbix with some sample data, that will be better.
Thanks.
Aiolos Zhao
Proud to be a Super User!
Yes I can share a file, but can you let me know how...I don't see the option
Or share your email address.
Thanks a lot for your help! This is really nice to have the ability to share knowledge like that!!
PY
Hi @Anonymous ,
You can upload the .pbix file on your drive and create a sharable link. That link can be shared here.
Thanks,
Pragati
Hi @Anonymous ,
It doesn't seem to work. You have to create a free downloadable link.
Thanks,
Pragati
Hi
We have some restrictions it looks like...
Try that one 😉
https://drive.google.com/file/d/1v47QNEapAhOfXxhZ44G9JF-J9l93CDPY/view?usp=sharing
Hi @Anonymous ,
Your .pbix is downloadable now.
It has got so many file.
Which 2 datasets are creating relationship issues? Can you please name them here as in your .pbix file?
Thanks,
Pragati
Yes sorry, I am jumping between subjects
If you look at Page 1 : the three tables are showing thr Stelling Id
- From Sales by Day (table on the left)
- From Stelling Master data (table in the middle)
- the effect with the relation ship
If you look at the relationship manager, the relation that I want to work is between Sales by Day table and Stelling_Master_data on field StellingID and StellinID
So far, I don't see why, the join des not work
Hi @Anonymous ,
1. You relationship netween the tables "Sales by Day" and "Stelling_Master_data" on column "StellinID" is perfectly right.
2. In you .pbix file on "Page1" tab, 3rd table on the right, you have moved Stellin Id from both the tables but you get blank data for StellinID from "Stelling_Master_data" against the StellinIDs coming from "Sales by Day". The reason for this is, these StellinIds don't exist in your "Stelling_Master_data".
Unique StellinId count in "Stelling_Master_data" = 136
Unique StellinId count in "Sales by Day" = 16
There exist no common "StellinIds" in these two tables.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Hi
Well, ok, the issue is between the keyboard and the chair 😉
Actually, my brain can read VKPSR028 and VPKSR028, and this sthe same...
Thanks for the realignment 😉 And sorry for my dumb question
HI @Anonymous ,
No question is a dumb question. 🙂
Keep learning! Keep Exploring New!
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Hi @Anonymous ,
Can you post some sample data from the both the tables here please?
Thanks,
Pragati
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |