Connectin to a Excel file from the internet

[Nilsoo]

Hi,

My dataset is an excel file that I have to download from a webpage everyday.
Does anybody know a solution to connect the excel file directly to Power BI?

So far I download the Excel File and replace the old one. Then I installed a personal-gateway that allows Power BI to get data from my personal computer. So once I "refreshed" the excel file my data is in Power BI is also refreshed. 
It would also help if the download appears automatically. Unfortunately, I have no idea how to solve this.

Best.
Nils

[v-qiuyu-msft]

Hi @Nilsoo,

Which web page did you mean? If it's stored in OneDrive or SharePoint, you can use the web data source to get data directly in desktop follow Use OneDrive for Business links in Power BI Desktop. Also you can connect to Excel in Power BI service: Get data from Excel workbook files.

Best Regards,
Qiuyun Yu

[Nilsoo]

Its located on a webpage from Microsoft. So I always have to download the excel file there which replaces the old excel file. I want to automate this that the dashboard refreshes automatically.

[Anonymous]

Hi Nilsoo

Have you solved your problem?
If not, please send me the link of the microsoft page and I'll help you.

[Hvaldes]

Hello

Could you help me with this please?

Thanks

[Nilsoo]

Hi,
I am not feeling good about giving you the Url of the pop-up window. The problem is that you can only get a link of pop-up the window that starts downloading the Excel-File and not from the Excel File itself.

[Hvaldes]

Hello

I would like to know if this issue was solved or not?

I'm have the same problem, I need to create a dataset in powerbi but the file is from website ( I have the link to get directly the xls).

Does anyone know if there is some way to solve?

[Anonymous]

Hi Nilsoo
Easiest way would be to copy the link of the excel file. You can get the link by right-clicking the file.

If this doesn't solve your problem, you may send me the url and I'll try to figure it out.

Beste

Hp Pfister