Forum Discussion
PBI Service Data <> Local Data after Publishing
Good morning all,
So here's my issue, I have a measure in a table that calculates correctly locally. Measure calculates to approx. 467M (relative for magnitude). Data has been updated locally. Publish to service and all the other data is correct (as in it's no different from the local file), but this one measure. It shows a value of 71M (irrelevant other than for magnitude). So I'm ruling out that I'm missing a few days or even weeks worth of data. Any ideas?
Ok so here's what i've found. I have a T/F column coming from my SQL source that is formatted in PQ as True/False. For some reason, it was transformed in PBI (not PQ) to a text column. I use this column in a switch statement. However, when i publish to the service, and i add that column to the filter pane, it gives me the option of 0 and -1, instead of "True" and "False".
To further the True/False column, if i select the (-1) {which should be a "true" in text at this point} in the filter pane, i get a popup that says "This visual contains one or more filters with deleted columns, type mismatches, or other breaking modeling changes" and the visual errors off.
so i've identified the issue, now to fix.
thank you for the willingness to help!
5 Replies
Ok so here's what i've found. I have a T/F column coming from my SQL source that is formatted in PQ as True/False. For some reason, it was transformed in PBI (not PQ) to a text column. I use this column in a switch statement. However, when i publish to the service, and i add that column to the filter pane, it gives me the option of 0 and -1, instead of "True" and "False".
To further the True/False column, if i select the (-1) {which should be a "true" in text at this point} in the filter pane, i get a popup that says "This visual contains one or more filters with deleted columns, type mismatches, or other breaking modeling changes" and the visual errors off.
so i've identified the issue, now to fix.
thank you for the willingness to help!
Solution: i added a custom column of type TEXT for the T/F and used that in my measure and filter pane. so far so good.
Tried that, no luck.
I've managed to narrow it down to this. The measure in question contains a switch true that looks for 3 statuses, "closed", "In progress" and "unstarted". It is omitting the "In Progress" status. So I've added the status to the filter pane, and sure enough when I filter for "In Progress" only, the row goes blank. The odd part about it is that if i add the measure to another table, I have no issues with it.
