web content csv file access forbidden

[Anonymous]

Hi,

I am trying to access a csv file on a website, but I get "Access is forbidden" message in powerbi.

The weblink to the csv in the browser works fine. 

Any help?

[Anonymous]

Hi @JoeBarry , 

Thanks for your response.
Yes the link is public: https://www.dnb.no/portalfront/datafiles/miscellaneous/csv/kursliste_over_EN.csv?_=1693227901701

[JoeBarry]

Hi @Anonymous 

I face the same issue. I tried with a few CSV download possibilities, but i get the same error message.

Can I offer an alternative? I use https://exchangerate.host/ You can download a whole year at a time and I refresh automatically on a daily basis to get the new rates. It is a very accurate rate. Do some spot checks on a date against a specific currency.

• Open the web connector
• Enter this url 

https://api.exchangerate.host/timeseries?start_date=2023-01-01&end_date=2023-12-31&base=NOK&symbols=USD,GBP,AUD,BHD,BRL,CAD,CLP,CZK,HKD,HRK,IND,INE,INR,INY,JPY,KGS,MXN,NAD,,NZD,RON,SGD,UAH,ZAR

• Connect anonymous
• Convert to Table
• Expand Value

You can add or remove currencies that you don't need. To add just know the 3 character currency code. 

What I done was create a dataflow. I created a query for every year up to 2030. Then I appended all queries into one. I unticked Enabled on the other queries and then saved the dataflow and scheduled a daily refresh at the end of each day. I then imported this table into Power Bi using the Dataflow connector.

Thanks

Joe

If this post helps, then please Accept it as the solution

[JoeBarry]

hi @Anonymous 

Is the link public? Can you share for testing?

Thanks

Joe