Power query loads data incorrectly, seperates values/only load part of the value

[Roodakker]

In the datasource the statuses are correct: 

 

But when loaded into power query they split into many diffrent statuses. 

Please help! How can I solve this? 

[Anonymous]

Hi @Roodakker ,

Can you tell me what your data source is? And how you are connecting to that data source?
Also, can you describe what the data looks like in each project after loading into Power Query, and if there are any data transformation steps performed during the loading process?
If you are using the Split function, make sure that the correct separator is selected. If the separator in the data is not a commonly used separator, you may need to specify it manually using the Customize option.

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

[Roodakker]

Hi, thank you for your reply. 

There is a split by delimiter function in the query, but it is split by 'comma' and nothing special about it. I solved it by creating a conditonal column adding all the statuses again only based on the numbers from the statuses in the original column. 

Best regars, 

Ronja