Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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.
Hi Nilsoo
Have you solved your problem?
If not, please send me the link of the microsoft page and I'll help you.
Hello
Could you help me with this please?
Thanks
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.
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?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.