Get data from URL adres which contains #

[Kasia123]

Hi,

I am trying to read the data from URL which contains # - example: https://makeup.pl/categorys/23466/#offset=36
In this case my query reads only the first part of adres up to # which is https://makeup.pl/categorys/23466.

My source is the following:

Source = Table.FromColumns({Lines.FromBinary(Web.Contents("hhttps://makeup.pl/categorys/23466/#offset=36"))})

How could I modify the code to read the whole page in adress?

[ppm1]

Try replacing # with #(#).

Chris Webb's BI Blog: Character Escape Sequences In M (crossjoin.co.uk)

Pat