Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Automatic data refresh from web fails

Hi all,   ANY help is appreciated as i am at a total loss of what to do...   I have created an automatic web-datasource that updates daily through the program E-conomic and their rest-api.    I...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Anonymous 

 

It looks weird. I think it may be caused by some transformation steps rather than the refresh process in service.

 

Do you query the cost prices and inventory quantity data into columns directly from the REST API? Do you perform some transformation steps like extracting, splitting columns, changing column data types with Power Query? Is it possible that some price values have lost the decimal point in transformation so they look multiplied by 100?

 

You can check the initial price values before any transformation. If the initial prices are correct, compare them with the final prices after all transformation steps in Power Query Editor. If some of them are different, check steps one by one to find out from which one it starts to become incorrect and correct the specific step.

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.