Load CSV files stored in market place website

[chiru_kudupudi]

Dear Experts,

I have to download excel files stored in below website daily and load into Power BI. The site need US vpn to access it. I am using hola app to connect the site. Is there chance to load those csv files directly from power query? 

https://marketplace.spp.org/pages/hourly-generation-capacity-by-fuel-type#%2F2019

Thanks,

Chiru

[v-juanli-msft · Accepted solution]

Hi @chiru_kudupudi 

Can your server access to the website?

Please work with your IT department to properly set the VPN settings to allow your access to the website.

Then you could connect to the website under Odata connector.

Connect to OData feeds in Power BI Desktop

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[chiru_kudupudi]

Currently we are using trail period VPN (Hola VPN). We need to purchase licienced one.

Is there any other solution for my problem?

Thanks in advance.

[chiru_kudupudi]

Thanks for your inputs. I will contact my IT team and do as you suggested. Will let you know once i

tried the odata field. I don't have prior knowledge of odata how to use it. Based on link provided i work on it.

Thanks again for your great support!!