Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Excel auto-refresh when Power BI does an auto refresh

I inherited a PBI project done by a coworker. He was not terribly familar with DAX so he took some shortcuts and did all of the data manipulation and calculations in Excel, which in turn has two data connections to two different SharePoint lists.

I've moved the Excel file to an online SharePoint docment folder and redirected the data connection to there. I then set up the actual report to auto-refresh once every 24 hours. I'd like this to also trigger a refesh in the Excel data connections so there's no user intervention necessary.

Is this possible? Our SharePoint is all hosted in the cloud (except restricted data, which this is not). 

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks, but this seemed about embedding Excel into web parts. I saw no menion of auto-updating anything.