Cloud and desktop version showing different results
Hello everyone, I hope I got the right forum... and I also hope someone can help me to understand where the problem lies. On my MySQL database I have one table GoalsTarget with these values: Name|Target milestone Goal 1 | MS01 Goal 2 | MS01 Goal 3 | MS03 Then I have anothe table GoalsForecast with these values: Name|Forecast milestone Goal 1 | MS01 Goal 2 | MS02 Goal 3 | MS05 Then I have a view v_results that gives an overview on which goal will reach the target ("1" is "Yes", "0" is "No", of course) Name|Forecast|Target|Meet Goal 1 | MS01 | MS01 | 1 Goal 2 | MS01 | MS02 | 0 Goal 3 | MS03 | MS05 | 0 If I pull these data on pbi desktop, everything works fine (the "T" is the equivalent of the "Meet" column, i.e. if "Forecast" = "Target"). I then publish it on the cloud, and everything is still fine. When the scheduled refresh kicks in, I have always "0". If I pull the data from the desktop at the same time, the data are still fine. I really don't know where the problem could lie... any suggestion?
