Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.