Forum Discussion
Get data from web not displaying table on my version
Hello,
I've already took a look here https://datachant.com/2017/03/30/web-scraping-power-bi-excel-power-query/
I know there's a way to get over it, but I have a strange behavior that I want to expose :
I want to get the table from https://www.imdb.com/search/title/?year=2019&title_type=feature&
As you can see, Power BI is not able to get the table :
I aske someone, using the same version of PBI than me (V : 2.79.5768.1082 64-bit (mars 2020)) but in English, to add the same source and send me the file, and it's actually working for him :
I know I can drill down manually throw the HTML structure using https://datachant.com/2017/03/30/web-scraping-power-bi-excel-power-query/ but here it's quite a mess.
My source is : Source = Web.Page(Web.Contents("https://www.imdb.com/search/title/?year=2019&title_type=feature&")),
His source is : Source = Web.BrowserContents("https://www.imdb.com/search/title/?year=2019&title_type=feature&"),
Why is it different ?
Have you any idea ?
6 Replies
- Greg_Deckler
Community Champion
Sounds like a bug that should be brought to the attention of the developers. You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".- ImkeF
Hi Anonymous
the Web.BrowserContent-Function will automatically be applied if you go via the "Add tables using examples"-way. Different methods, resulting in different formulas:
- amitchandak
Super User
Refer, if this can help
https://www.thebiccountant.com/2020/04/06/download-files-from-webpages-in-power-query-and-power-bi/
Or other article from ImkeF on https://www.thebiccountant.com/
