Forum Discussion
Get xlsx file from website
Hi guys, I am trying to find solution how can i link external data source to PBI . In my case my data is .xlsx file located on web page, and i have several of them. So basically i need get excel f...
lbendlin
Super User
Super UserThat is sub optimal. Would have been better if they Excel files were on a Sharepoint.
Can you do a folder contents listing on that web site, or do you know when which files appear?
Hi
Thank you for reply.
Data refreshes each day (mostly).
I was thinking using web scraping tool or something simillar.
Basicly, i would like to automate it if possible.
Automaticly download files to folder (sharepoing or local) and then PBI pulls them.- lbendlin
Talk to the website owner, maybe they can allow directory browsing for that folder.
