Forum Discussion

Quentin's avatar
Quentin
Helper IV
5 years ago
Solved

Difference in Refresh data between desktop and service

I have a report with 2 conectors: Sharepoint list (10 lists) and Sharepoint Conector, credencial OAuth2 level of security private When i actualize in PowerBi Desktop, everything's fine When i pub...
  • Quentin's avatar
    5 years ago

    Dear GilbertQ and anyone who comes accros this...
    Thank for the response i found the error but it couldnt be found by the indication i was giving.
    Let's all be aware that Desktop and Service do not read sharepoint list exactly in the same way!

    While on desktop a True/False column in a sharepoint list was read "TRUE" or "FALSE" and it works to make measures on condition ="TRUE", the service reads it as 1 or 0 and therefore the measure do not return the same value, giving the impression the actualization takes part of the data....

    I spent 2 days on it looking at the wrong direction... 😞 
    Thanks again for participation and guidance!