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

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