Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
DanCerf
Frequent Visitor

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").

Desktop versionDesktop version

 



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.

Cloud version after the first "scheduled" refreshCloud version after the first "scheduled" refresh

 

I really don't know where the problem could lie... any suggestion?



1 REPLY 1
DanCerf
Frequent Visitor

Anyone? Any idea?

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.