Forum Discussion

drop's avatar
drop
New Member
9 years ago
Solved

Auto refresh data from an Excel in Sharepoint

Hi, I created a Power BI file using multiple Excel files in Sharepoint as a data source (Get Data -> Sharepoint folder -> combine Excel files). The Excel files have the query uploaded as data model....
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi drop,

    Power BI can't automatically refresh FTP data source. You can consider to use Power update to refresh CSV file connected in your Excel.


    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi drop，

Do you connect to SharePoint online folder or folder of on-premises SharePoint site in Power BI Desktop? Do you connect to other data sources in your Excel file?

If you connect to folder of on-premises SharePoint site, you would need to install gateway in order to set schedule refresh for your dataset.

Thanks,
Lydia Zhang

  • drop's avatar
    drop
    New Member
    9 years ago

    Hi Anonymous,

    Thank you for your reply.

     

    I'm connecting to SharePoint online folder and the Execl file I'm connecting to is connected to CSV files in an FTP folder. I'd need to have the Power BI service to automatically get the updated data without manually opening and update the Excel file.

     

    Hope you can help me with it.

    Thank you.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi drop,

      Power BI can't automatically refresh FTP data source. You can consider to use Power update to refresh CSV file connected in your Excel.


      Thanks,
      Lydia Zhang