Forum Discussion

michellepace's avatar
michellepace
Icon for Resolver III rankResolver III
3 years ago
Solved

Excel converts number into string when connecting to PowerBi dataset

Hello,

 

I have a dataset in power bi where "preclong-x" and "preclat-y" are defined as numbers (I checked in power query within power bi). When I connect to the power bi dataset from excel, the number is changed into a string. I need for it to remain a number. Is there a way to do this? 

 

 

Thanks in advance,

Michelle

Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, michellepace 

     

    I have not been able to reproduce your question. Whether you can change the data format to Number where shown in the figure.

     

    Best Regards,

    Community Support Team _Charlotte

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

1 Reply

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi, michellepace 

     

    I have not been able to reproduce your question. Whether you can change the data format to Number where shown in the figure.

     

    Best Regards,

    Community Support Team _Charlotte

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