Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

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 :

pbi3.png

pbi4.png

 

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 :

pbi1.pngpbi2.png

 

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 ?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

 

unnamed.png

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

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

 

unnamed.png

Greg_Deckler
Community Champion
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".



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

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:

 

image.png

 

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Anonymous
Not applicable

Not working at all 😕


pbi5.png

ImkeF
Community Champion
Community Champion

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 

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

amitchandak
Super User
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/

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.