connect an excel with power bi from an url

[vicentetic]

it should be elementary but I can't find the way. I want to connect power bi with an Excel file in a URL, specifically this one (https://apps.fomento.gob.es/BoletinOnline2/sedal/32100500.XLS) but I find it impossible. can anyone help me?

Thanks.

[rubayatyasmin · Accepted solution]

HI, @vicentetic 

did you use web connector? 

look at this documentation. https://learn.microsoft.com/en-us/power-query/connectors/web/web

or another way is use python scripting. for example, get data >> other >> python script >> connect

import pandas as pd
import requests
from io import BytesIO

url = 'https://apps.fomento.gob.es/BoletinOnline2/sedal/32100500.XLS'
response = requests.get(url)
data = pd.read_excel(BytesIO(response.content))

data

hop that helps. 

[vicentetic]

Thank you. It's working. I had tried the connector but it gave me an error and it was that I had to update access software. Now everything is ok

[rubayatyasmin]

Happy to help. 

Appreciate the kudos. 👍

[Dhairya]

Hey @vicentetic 
Please try using "web" as Source in Get Data option.