Forum Discussion

bbaumgartner's avatar
bbaumgartner
Frequent Visitor
8 years ago
Solved

Power query editor has changed type errors with new source

Whenever I want to change the data source of my dashboard, I always get an error at the "Changed Type" step of my query. I have to repetedly delete this step and reassign all the data types to get my...
Need Help
  • bbaumgartner's avatar
    bbaumgartner
    8 years ago

    Hi v-jiascu-msft,

     

    I just looked more closely at my table and realized my field is actually called "SalesOrderNumber". In the Formula Bar, it's recorded as "Sales Order Number". I'm not sure why that happened-- is there a default setting that possibly serparates the text? I just deleted the spaces in Sales Order Number and everything worked perfectly. 

     

    Appreciate your help with this issue, thank you for looking in to it!

     

    Best,
    Bonnie

bbaumgartner's avatar
bbaumgartner
Frequent Visitor
8 years ago

Hi v-jiascu-msft,

 

I just looked more closely at my table and realized my field is actually called "SalesOrderNumber". In the Formula Bar, it's recorded as "Sales Order Number". I'm not sure why that happened-- is there a default setting that possibly serparates the text? I just deleted the spaces in Sales Order Number and everything worked perfectly. 

 

Appreciate your help with this issue, thank you for looking in to it!

 

Best,
Bonnie

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Bonnie,

 

Thanks for sharing. The most possible cause is the data source. Almost every step of Power Query will refer to the last step. It won't change any name like that.

 

Best Regards,

Dale