Retrive a table from the web in power Query for Ex...

Syndicate_Admin · ‎03-24-2023

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 · ‎03-24-2023

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

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin

Proud to be a Super User!