Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Retrive a table from the web in power Query for Excel

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

1 Reply

  • 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