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
    3 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!

     

Anonymous's avatar
Anonymous
Not applicable
3 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!