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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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