Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Not applicable

web content csv file access forbidden


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?

Not applicable

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 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 
  • 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.





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


Solution Sage
Solution Sage

hi @Anonymous 


Is the link public? Can you share for testing?




Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors