Web content problems

[Anonymous]

Hello,

1. I am working on a Power BI report with multiple Web Content sources that I wish to extract data of. For some of these sources, Power Query shows this error.

         2. When I click on Refresh, the error disappears but when trying to load the tables into the report I get the following timeout error

         3. Furthermore, whenever I use a Web source in my Power BI reports, I lose access to Source Identificaction Info when I publish the report.

Is anyone facing similar issues?

Thank you for your help

[Syndicate_Admin]

That source expects a POST call.  Web.BrowserContents cannot do that,.  Use Web.Contents instead and put the query parameter in the body of the request.

Also note that the query is different. 

https://plasticker.de/preise/preise_monat_single_en.php?auswahl=Ballenware;PP&dauer=60

[Anonymous]

Hello,

First of all thank you for your reply.

I already tried it, but the problem is that some websites return an empty table when replacing Web.BrowserContents by Web.Contents.

Here is an example: https://www.insee.fr/fr/statistiques/serie/010002062#Tableau

let
Source = Web.BrowserContents("https://www.insee.fr/fr/statistiques/serie/010002062#Tableau"),
#"Table extraite à partir de code Html" = Html.Table(Source, {{"Column1", "TABLE[id='tableau-series'] > * > TR > :nth-child(1)"}, {"Column2", "TABLE[id='tableau-series'] > * > TR > :nth-child(2)"}, {"Column3", "TABLE[id='tableau-series'] > * > TR > :nth-child(3)"}}, [RowSelector="TABLE[id='tableau-series'] > * > TR"]),
#"En-têtes promus" = Table.PromoteHeaders(#"Table extraite à partir de code Html", [PromoteAllScalars=true]),
#"Type modifié" = Table.TransformColumnTypes(#"En-têtes promus",{{"Année", Int64.Type}, {"Mois", type text}, {"Valeur", type number}})
in
#"Type modifié"

Do you have any explanation for why the code is returning an empty table?

Thank you again,

Wassim

[lbendlin]

No explanation - the same code works fine for me.

let
    Source = Web.BrowserContents("https://www.insee.fr/fr/statistiques/serie/010002062"),
    #"Extracted Table From Html" = Html.Table(Source, {{"Column1", "TABLE[id='tableau-series'] > * > TR > :nth-child(1)"}, {"Column2", "TABLE[id='tableau-series'] > * > TR > :nth-child(2)"}, {"Column3", "TABLE[id='tableau-series'] > * > TR > :nth-child(3)"}}, [RowSelector="TABLE[id='tableau-series'] > * > TR"]),
    #"Promoted Headers" = Table.PromoteHeaders(#"Extracted Table From Html", [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Année", Int64.Type}, {"Mois", type text}, {"Valeur", type text}})
in
    #"Changed Type"