Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 ?
Solved! Go to 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
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
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".
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:
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
Not working at all 😕
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
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/
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |