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!

     

Ruchita's avatar
Ruchita
Icon for Helper I rankHelper I
2 years ago

Hi,

Did you find solution to this problem? I am having the same issue. Every refresh from Power BI service giving different figures.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

My issue was solved by cleaning and trimming the joined elements (Text.Clean(Text.Trim([Field])) in both tables

  • Ruchita's avatar
    Ruchita
    Icon for Helper I rankHelper I
    2 years ago

    Thanks Vincitori for replying back.

     

    I also tried this. I cleaned and trimmed the columns which are used for joins in both the tables. But still the problem persists. I have raised a support ticket with Microsoft and its been more than 20 days, they haven't been able to find any solution.