Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Data refresh is giving unpredictable and incorrect results

Hi all,   I have a very strange behaviour in one of my Power BI reports. In short we have the following situation: - Report is developed on desktop using imports from an Azure database. Within the...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    I think I've found the solution for the above issue!

    As I'm deriving the dimensions from the master table, I was expecting the items, I use to join between the fact table and the dimension, to be the same.

    I suspect one of the elements to contain special characters and/or leading/trailing spaces, so I inserted in the power query 2 steps to trim and clean the text strings and it looks like this solved the issue!

     

Ruchita's avatar
Ruchita
Helper I
2 years ago

I was also doing a similar thing and similar error. I was creating an index col in the dimesion table and then linking the fact and dimesion tables on this index key. Instead, now I am creating a custom column by concatenating the 2 primary keys in both the tables. This custom column is now used to create the relationship between the 2 tables. This solved the issue.