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,
I usually run a report on a website and download that as a excel file. I can see the table in the webpage. How do i connect that website to Power BI. I tried copying in the URL but doens't work. I'm I missing any steps?
Thanks
If you have Power Automate Desktop and access to a spare computer or virtual machine, then you could try the set-up I explain here:
@drallam wrote:
Hi,
I usually run a report on a website and download that as a excel file. I can see the table in the webpage. How do i connect that website to Power BI. I tried copying in the URL but doens't work. I'm I missing any steps?
Thanks
My guess is that probably you can't simply get the data from the "table" via the "get data"->"other"->"web" with the report site url. Two questions,
Hi Eric,
@drallam wrote:
Hi Eric,
- Yes there is an authentication to access the data before running the report.
- The idea is to exprot that data to an excel file after running the report. And I load that to power BI. I was wondering if there a way to directly pull that data. Or what would be the ideal workflow to do it would be the greater question.
I'd say it depends on your report app. If you can get the correlated API loading data, you may call that API directly to get data in Power BI.
Try entering the URL into a Web query and using the visualize page option to select the table?
Where do i see that option.
Get data | Web. After you enter the URL you should get a dialog with the Document and any tables listed. You can then click on the "Web View" tab at the top to see the web page and it should highlight the tables and allow you to checkmark the ones that you want to import.
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.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |