Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Changing Data type in Edit Queries or Modeling

Hi, 

 

I am getting data from Excel sheet and some of the field's data type needs to be to changed. I have always done this modification through Edit Queries. However, it was not reflecting the changes after Close&Apply. So I had to do in Edit Queries and Modeling. 

 

I would like to know more about this! Why this was happening? and what is the reason? 

 

Regards, 

 

Fatima.

General Comment

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    7 years ago
    Hi there

    It should work perfectly fine when going into the Power Query Editor

    The only thing I could initially suggest is if you have got the latest version of Power BI Desktop installed?
  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Anonymous 

    Is this problem sloved?

    If not, please let me know.

    Please show me an example to reproduce your problem.

     

    Best Regards

    Maggie