Forum Discussion
AdministratorConexion FEEFO - Power Bi
Hello everyone!
I am a relatively new user in PowerBi and the company where I work is looking to make statistical data related to the customer experience with our products.
To this end, we implemented the use of a platform called FEEFO (https://business.feefo.com/), which allows us to register and rate our products.
The problem I have is that when I connect PowerBi to the FEEFO website, only the first page of feedback is imported and I need to have all the pages.
The connection was made through the "WEB" option
FEEFO recommends downloading the information from the website to Excel and then uploading the Excel to PowerBi... but for a reason of practicality I prefer not to use this option.
Could someone guide me if there is a way to make the connection to all the information available on the FEEFO website?
Thank you very much
Pablo
Syndicate_Admin Here's an example of extracting all of the information from a series of pages. (PBIX is attached below signature). Let me know if this helps. You can watch my video on how it works here.
Here's another video as well that explains how things work.
4 Replies
- Greg_Deckler
Community Champion
Syndicate_Admin If the website has multiple pages of feedback, often this is handled with a query string parameter at the end of the url such as ?page=1, ?page=2, etc. Does the FEEFO website work like that? If so, you can write a simple function to fetch the web results and append them together.
Syndicate_AdminYes, it works exactly like that, could you help me create that simple feature? I don't really have much idea about HTML.
Thank you
- Greg_Deckler
Syndicate_Admin Here's an example of extracting all of the information from a series of pages. (PBIX is attached below signature). Let me know if this helps. You can watch my video on how it works here.
Here's another video as well that explains how things work.
- Syndicate_Admin
Thank you very much Greg.
The solution worked very well for me, although I don't have much knowledge of Power BI I was able to replicate it thanks to your video and the file you attached.
I would just add that it is necessary for this solution to have 2 parameters (one with the url up to the number and another with the number of pages you want to download), a function and a related table.
I know that everything is in the video, but until I realized that the parameter with the URL was missing several hours xD
Thank you again
Best regards
Pablo