Here are some potential reasons you may be having difficulties.  This listing is not exclusive as there may be more issues.

• Reliance on JavaScript: Many modern websites use JavaScript to load and display data dynamically. If a web page relies on JavaScript to render content or tables after the initial page load, Power Query might struggle to capture this information because it primarily relies on parsing the static HTML structure.
• Dynamic updates: Pages that load their content dynamically can sometimes be inconsistent because the content can change after the browser considers loading complete. 

• Non-standard table formats: Power Query in Excel primarily focuses on identifying tables defined by <table> tags. If a website uses alternative methods like <div> tags or other non-standard approaches to structure tabular data, Power Query might not recognize it as a table, making it difficult to extract the data.
• Website structure changes: Even minor changes to the website's layout, design, or underlying HTML structure can disrupt the data extraction process if the scraper was designed for the previous structure. 

Thanks for your reply. I have worked around this by using AI. However AI can't generate it correctly either from the website addresses so to work around that I had to copy and paste the fixtures for it to generate it correctly. OK for a manual work around. Not ideal for other situations where I would require it to dynamically refresh the data when 3rd party users need to access that info.