Forum Discussion

HXM001's avatar
HXM001
Frequent Visitor
3 years ago
Solved

SharePoint data presenting as numbers instead of text

Hello all, I am new to Power BI and have been trying to use the Desktop app to generate reports linked to a SharePoint list that I set up. When I connect the data from the SharePoint list certain c...
Need Help
Tips and Tricks
Tutorial Requests
  • v-luwang-msft's avatar
    v-luwang-msft
    3 years ago

    Hi HXM001 ，

    You can try the steps below.

     

    Open Power Query Editor, remove any step in Query Settings that change your current Text Format into Number first.

     

     

     

    Then, select the orignial text column, right click to choose Change Type -> Using locale...

     

     

     

    Then choose Data type and your Locale

     

     

     

     

    Best Regards

    Lucien

v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi HXM001 ，

You can try the steps below.

 

Open Power Query Editor, remove any step in Query Settings that change your current Text Format into Number first.

 

 

 

Then, select the orignial text column, right click to choose Change Type -> Using locale...

 

 

 

Then choose Data type and your Locale

 

 

 

 

Best Regards

Lucien