Retrive a table from the web in power Query for Excel

[Syndicate_Admin]

Hello,

I can retrieve a table from the web into Power BI Desktop, but I cannot do the same thing into Power Query for Excel.

My customer does not have Power BI and wants to use Excel only

The table I am interested in is the following:

https://www.insee.fr/fr/statistiques/serie/010546452#Tableau

Do you have an idea about how to process in Excel?

Thanks in advance

[PhilipTreacy]

The Web.BroswerContents function that allows you to get this table in Power BI isn't available in Excel.  So you wont be able to load that table as it's generated by JavaScript and the functions in Excel can't read such tables unfortunately.

regards

Phil