Excel Autofill refresh in Power Bi Service

[pranim]

I have a Excel workbook  in One Drive for Business with formulas(Autofills). I am able to import that workbook into power bi desktop create reports and publish it to power bi service/online. But when i refresh the data its not showing me the autofill updated data but the data which doesn't have autofills are being updated(Name of the person, i have changed the format and tested). The data with autofills will not be updated when refreshed?

Thanks in advance!

[alanhodgson · Accepted solution]

Hey @pranim,

I ran into this same issue. The reason the Autofills will not update, is because the Excel file (an instance of Excel) never actually opens when the refresh from OneDrive occurs. It just looks at the data in the file.

I was able to bypass this issue by writing a simple python script that would open an Excel instance in the background and refresh the file (and update AutoFills). I did this because I had to do that same task for 30+ spreadsheets.

Here is a link to a similiar script of what I used.

Hope this helps,

Alan