Forum Discussion

devGV_88's avatar
devGV_88
Icon for Helper I rankHelper I
2 years ago
Solved

PowerBI Semantic Dataset Issue (Datatype change once is refreshed)

Hi there, Hopefully you can help me.   I have a semantic model published with many tables and relationship, but the issue is just with one column in a table. The data source is an External Table ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

devGV_88's avatar
devGV_88
Icon for Helper I rankHelper I
2 years ago

Really weird, because I have more than one column as Boolean but only this column change to 0/1.

I could understand if all of them have the same behavior.

 

Thanks for your response Anonymous, I will follow your recomendation.