Unable to connect to online csv file!

Power BI
1

Hi everyone,

I have encountered a problem which I am unable to figure out reason. I had built ARK invest portfolio tracking report. I was getting data using ark-fund website and links of all webpages were like below:

https://ark-funds.com/wp-content/fundsiteliterature/csv/ARK_AUTONOMOUS_TECHNOLOGY_&_ROBOTICS_ETF_ARKQ_HOLDINGS.csv

You can find the link by going to https://ark-funds.com/ → Active ETFs–>ARKQ and then right click “fund holding CSV” and copy link.

Anyhow, if you paste above link in browser, it will download latest csv file. Previously I was connecting it using Power BI web connector and I was able to bring it to Power BI. But now, it is throwing error “Access to this resource is forbidden”. Although I can download this file by browser, but why I am unable to access it using PQ. Previously it was working fine.

Anybody has a solution to this problem?

Kind Regards,
Hafiz

2

Hi everyone,

I got the reason now. I tried to get it using python script and I got below error notification:

“[‘Access denied | ark-funds.com used Cloudflare to restrict access’”

So, it means Cloudflare is allowing requests coming through web browser, but restricting access for all requests coming through other sources.

Regards,
Hafiz

2 Likes