Forum Discussion

Sharksguts's avatar
Sharksguts
Frequent Visitor
8 years ago

Refreshing data from gov.uk

I am trying to setup a Power BI dashboard to link to milk price data here https://www.gov.uk/government/statistics/uk-milk-prices-and-composition-of-milk   I am downloading the the ods file and ope...
v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Hi Sharksguts,

 

I have checked the milk price data from your shared link. In the ods file, there exists some useless data like the Title or Updated on or Contact etc. These data will affect the format of your excel file and cause the error. To resolve the error, I think you have to remove these data manually.

 

And generally if we want to update data automatically, we'll use scheduled refresh. Please refer to following article:

Configuring scheduled refresh

 

Thanks,
Xi Jin.