Forum Discussion
Data discrepancy between PBI Service and PBI Desktop
Update on this issue. I opened a ticket with support and it is a known issue. The bug is related to visual filters with Boolean values. In Power BI Desktop the values are True/False, however when published to Power Bi Service the values were changed to -1/0. The filtered value was True but in Power BI Service there was not value = True which basically rendered that filter useless.
DesktopServices - converted values to -1/0 but left the 'TRUE' value select. All Boolean data was converted so no values = True
Support provided a couple of work arounds:
1. Update data in Power BI Desktop to text value then republish
2. In Power BI Services manually select the filters to -1/0 after pubishing. Note: each time you publish it will be overwritten.
PS. Suport was very helpful and responsed withn two hours from when I opened my ticket.
v-ljerr-msft yes the desktop takes about 20 minutes as well. You mentioned that "there may be some data updates during these refresh durations" if there are data changes does that cause to the refresh to return incomplete/bad data? It is likely that are data updates, however I do have a schedule run late evening when no one is in the system and the data in PBI service is still off.
Thank you for your reponse. I will open up a ticket with Power BI Support.
Warm regards,
Kevin
Update on this issue. I opened a ticket with support and it is a known issue. The bug is related to visual filters with Boolean values. In Power BI Desktop the values are True/False, however when published to Power Bi Service the values were changed to -1/0. The filtered value was True but in Power BI Service there was not value = True which basically rendered that filter useless.
DesktopServices - converted values to -1/0 but left the 'TRUE' value select. All Boolean data was converted so no values = True
Support provided a couple of work arounds:
1. Update data in Power BI Desktop to text value then republish
2. In Power BI Services manually select the filters to -1/0 after pubishing. Note: each time you publish it will be overwritten.
PS. Suport was very helpful and responsed withn two hours from when I opened my ticket.