Automatic data refresh from web fails

[Anonymous]

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 am analyzing inventory data, where cost prices and inventory quantity data is extracted from E-conomic and the total inventory value is calculated in Power BI as cost price*quantity.

When I update the data in Power BI desktop, all calculations and the extracted data is correct. The same goes for the initial publish to Power BI Service. However, when the automatic update happens, either through a scheduled update or by updating through Power BI Service, most of the cost prices are multiplied by 100, so that the inventory value becomes way too high.

This only goes for about 400 out of 1800 item numbers. I tried to fix the issue by dividing the calculations by 100, but then i identified the approx. 400 item numbers, that would then result in an inventory value that is too low. I have identified the item numbers that differ by not failing in the update. Nothing ties these item numbers. I compared the item numbers that failed on two different dates, and not all of them failed both days. Some failed the first time and not the second and vice versa.

I have no idea what could be the reason for the refresh issue and any hints or possible reasons are much appreciated!

Kind regards

Anna

[v-jingzhang]

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.