Forum Discussion

Herndon_powerbi's avatar
Herndon_powerbi
Helper I
4 years ago

Power bi automatically changes data types

Hi,

      In our company we get data from sharepoint, sometimes unexpectedly PowerBi changes data types i.e Date field to text. then our visuals are broken. Could you please let me know what causes this issue and how to fix it.

 

Thanks in advance,

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Teach your developers to disable that setting in Power BI Desktop.

     

     

    Power BI tries to be helpful but most of the time it generates more work for you.

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi Herndon_powerbi 

    What's it raw type in datasource? will it work fine if you disable the feature mentioned by lbendlin ?

     

     

    Best Regards,

    Community Support Team _Tang

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