Different value in Power BI desktop and Power BI Web for SharePoint column of Yes/No datatype

[DigeshGala]

I observed that Sharepoint list column "Uploaded in SAP" of type Yes/No is reflecting different value in Power BI desktop and Power BI Web. Kindly refer the screen shot below for reference.

Power BI Web ViewPower BI Desktop Report ViewPower BI Desktop: Edit Query View

[bmavity]

I can't speak to the technical reason for the ocurrence, but I'd suggest changing the data type in the Query Editor from text to True/False.  That should fix the mix-up between desktop and web.

[v-qiuyu-msft]

Hi @DigeshGala,

As @bmavity suggested, please ensure the data type is True/False then republish to service. 

Best Regards,
Qiuyun Yu