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 nu...
  • v-zhangti's avatar
    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.