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...
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

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