Forum Discussion
How to get data from web page?
- 3 years ago
No problem, i've uploaded the PBIX file here:
https://drive.google.com/file/d/1ugFn0y3gecclOkQ-roXDXpC6zPAB1iqO/view?usp=sharing
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi,
you can just select get data, select the web option and input that link,
then select the table:
Click Transform Data, then on the transform ribbon promte 1st row as headers:
this should get you what you need:
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Dear DOLEARY85 , thanks a lot for your help but I get different results doing the same as you.
Step 1:
Step 2:
As you can see, I can get only the internal structure of the page but not the data in the table.
If you can, please send me your PBIX file or some tip to do it as you do it.
Best Regards and thanks a lot.
- DOLEARY853 years agoResident Rockstar
No problem, i've uploaded the PBIX file here:
https://drive.google.com/file/d/1ugFn0y3gecclOkQ-roXDXpC6zPAB1iqO/view?usp=sharing
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
- Dreamer_Argento3 years agoHelper I
Thanks DOLEARY85 ! You are my hero !