Get data from web not displaying table on my version

[Anonymous]

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 ?

[Anonymous · Accepted solution]

Ok, the problem came from this option, if it's not enabled, the table is not recognized.

I might be something like "New web table interface" in English

[Greg_Deckler]

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:

[Anonymous]

Not working at all 😕

[ImkeF]

You have to start entering sample values for PBI to pick it up. Please read the manual or watch this video: https://www.youtube.com/watch?v=s_5Jk8_fHjA 

[amitchandak]

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/