Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello BI community,
I'm seeking some advice on wrong data return, I have problem with my product dimensions where it return wrong product code and category for the order. I create sale table view in SSMS and the use that table to create another view call products dimension, which I put condition to creat category. I import that product table to Power bi and created index as productID then merged to fact sale table, then use productID as relationships, but the product and category keep changing and missed match to the original order product after refreshing data set. I wonder how could I fix the problem or what has happened? Thank you.
Such issues can't be diagnosed without data. Sorry.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
165 | |
83 | |
68 | |
68 | |
59 |