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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

web content csv file access forbidden

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?

3 REPLIES 3
Anonymous
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 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 
  • 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.

 

JoeBarry_0-1693287689975.png



Thanks

Joe

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

 

JoeBarry
Solution Sage
Solution Sage

hi @Anonymous 

 

Is the link public? Can you share for testing?

 

Thanks

Joe

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors