How to get CSV files from links on a web page?

[MrFahrenheit]

Hello everyone - How can I get these CSV files into Power BI? The files are on a website which I do not need to log into.

Please see the attached screen shot.

Thank you

[v-jingzhang · Accepted solution]

Hi @MrFahrenheit 

Are you able to right click on a file and select Copy link address option? Then go to Power BI Desktop, select Get data > Web and enter its link address in URL input box to test whether you can get data from this link. 

If it's possible to get data from a file, then check the format of its URL. If all file URLs have the same format except for a different id or file name part, we can consider getting all URLs from this website first, then creating a custom function to get data from all files through all URLs. One option you can try is to enter the website url into URL input box to see if you can extract all file names and their URLs into a table.

These docs should be helpful:

Power Query Web connector - Power Query | Microsoft Docs

Extract data from a Web page by example - Power Query | Microsoft Docs

Using custom functions in Power Query - Power Query | Microsoft Docs

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[negi007]

@MrFahrenheit is it possible for you to open the web page as web folder. if you are able to achive that then you can specify the folder location in the data source in powerbi to import data from a web folder.

see if below link can help you to open your web page in windows explorer as a folder then you can copy and paste the url in powerbi to connect and then merge these csv files if they are in the same format.

https://answers.microsoft.com/en-us/windows/forum/windows_7-networking/how-to-open-web-folder-in-win...

[MrFahrenheit]

I tried and the operation failed. Thank you for the suggestion, I can see how that would work.