Forum Discussion
PowerBi Dashboard shows different values from Desktop
- 3 years ago
We solve this:
In sharepoint we made the column originally with a column name of "Outcome" but it was renamed to "Result" at some point.
In powerbi desktop, we have the code "Last Completed Milestone = calculate(DISTINCTCOUNT('Sharepointsite - milestones'[MilestoneName]),'Sharepointsite - milestones'[Result] = "True")".
We made a connection to sharepoint using implementation 1.0 and it worked, but it also showed the column as "Result" and not the internal name of "Outcome".
When we published to powerBI service, it was using (what we guess) to be implementation 2.0 and it load the sharepoint site with the same colum being named "Outcome" and not the display name of "Result".
Because of this, the first measure would not be able to evaluate the logic and would result in no values. Because of this dependent measure returning no values, the next measure would return the else condition.
We solved this by just changing implementation to 2.0 (Was a bit of a pain) in powerbi desktop and rewriting the first measure to use the "Outcome" column. This solved the problem.
Here I will show this:
When I press "publish" on the desktop version, while the online dashboard is still loading, it will show the right stuff in the online dashboard until the "refresh" finishes:
The student last completed milestone 4, and the next milestone is the proposal defense (a numerical value of 5). This is what the dashboard should show.
This is perfect!
When I view the dataset for the tracker while it is still refreshing, it will show everything perfectly.
However, when it finally refreshed all the way (no more spinning circles):
The same student selected no shows no records for them and it just gives it the default last milestone.
Why?
I even refreshed the visuals. I cleared my cache in my browser. Tried another browser. It just seems to lose the relationship between the 3 tables somehow in the online dashboard.
Why does my dashboard work on my desktop version, and fine when it is refreshing, but after a refresh, it will just "lose" data?