Forum Discussion

pranim's avatar
pranim
Helper I
9 years ago
Solved

Excel Autofill refresh in Power Bi Service

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!

Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • alanhodgson's avatar
    alanhodgson
    9 years ago

    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

1 Reply

  • alanhodgson's avatar
    alanhodgson
    Solution Supplier
    9 years ago

    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