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.
Hey Friends,
I've got a report that uses an excel file as a source. I need it stored on Sharepoint online.
I've been trying to get it to schedule a refresh so it updates at least once a day.
I've found some different suggestions online that included:
Use the "Excel" connector but switch it to web content and use the URL from the Excel File:
I've tried switching it to the "Web Connection" as well.
no matter how I set it up, schedule refresh is grayed out
THere is also some confusing documentation that says it will auto update if it's on sharepoint online, but I'm convinced that's happening.
Any guidance would be great!
Thanks,
TMW
Solved! Go to Solution.
HI @Anonymous ,
It sounds like you are use web connector with excel file from sharepoint online.
If this is a case, power bi will use onedrive refresh mode to handle your datasource and you not need to set up scheduler refresh.
Regards,
Xiaoxin Sheng
HI @Anonymous ,
It sounds like you are use web connector with excel file from sharepoint online.
If this is a case, power bi will use onedrive refresh mode to handle your datasource and you not need to set up scheduler refresh.
Regards,
Xiaoxin Sheng
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.