Forum Discussion

KevinSanDiego's avatar
KevinSanDiego
Icon for Advocate I rankAdvocate I
8 years ago
Solved

Data discrepancy between PBI Service and PBI Desktop

Hi,   I am fairly new to PBI and have generally found solutions/answers to my issues/questions I've encountered thus far on the community posts -- this has been an amazing resource to help me learn...
Need Help
  • KevinSanDiego's avatar
    KevinSanDiego
    8 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello,

 

I've been facing similar issue. We recently added a step to our backend model to fix a recurring refresh issue. When we publish the file to service and do a scheduled refresh, the refresh succeeds but a few values turn to 0s whereas the same doesn't happen when I refresh locally. 

 

So I tried changing the datatype of our filter but it didn't work. I downloaded the refreshed copy from the service, try to delete the change we made earlier to fix the refresh issue and refresh, the values came back to normal. If I do the same on my local (delete the step and refresh), the values don't change. Kindly help me figure out why the values change to 0s when a scheduled refresh completes on the service but not locally.

Thanks in advance 🙂