PowerBI Semantic Dataset Issue (Datatype change once is refreshed)

Hi devGV_88 ,

This behavior is related to how Power BI Desktop and the Power BI Service handle datatype conversions differently. In Power BI Desktop, boolean values (TRUE/FALSE) in a column with an ANY data type are retained as strings. However, when refreshed in the Power BI Service, the underlying engine converts these boolean values to numeric representations (-1 or 0).
After my testing, changing the column data type to True/False or Text type before publishing the report to Power BI Service solves the problem. Below is a screenshot of my test:
In Power BI Desktop:

In Power BI Service:

Data types in Power BI Desktop - Power BI | Microsoft Learn


Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.