Forum Discussion

mafdam89's avatar
mafdam89
New Member
8 years ago

Query with Web.Contents (POST) executed twice

Hello, I created a new power query (reported below) in an empty pbix file. The result is correct,(7000 rows csv file, compressed using gzip and encoded in base64) but if I trace the db or trace t...
v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi mafdam89

Are these two records in the trace file just the same?

Which datasoure do you connect to?

See a similar issue here solved.

 

Best Regards

Maggie

mafdam89's avatar
mafdam89
New Member
8 years ago

Hi Maggie
thanks for the reply,
yes, the records in the trace file are the same.
I have two file:

"Microsoft.Mashup.Container.NetFX40.10296.2018-06-05T10-21-56-390309.log"
with these lines:

DataMashup.Trace Information: 24579 : {"Start":"2018-06-05T10:21:57.6375414Z","Action":"Engine/IO/Web/Request/GetResponse","HostProcessId":"3884","RequestMethod":"POST","RequestUri":"https://www.myurl.com/servlet/myservlet","RequestHasContent":"True","RequestHasHeaders":"True","RequestHasTimeout":"True","UseCache":"True","ResponseStatusCode":"200","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"bfa72383-d67d-4092-b54e-3899689050e4","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10296,"Tid":1,"Duration":"00:00:00.0250342"}
DataMashup.Trace Information: 24579 : {"Start":"2018-06-05T10:21:57.6662339Z","Action":"Engine/IO/Web/Request/GetResponse","HostProcessId":"3884","RequestMethod":"POST","RequestUri":"https://www.myurl.com/servlet/myservlet","RequestHasContent":"True","RequestHasHeaders":"True","RequestHasTimeout":"True","UseCache":"True","ResponseStatusCode":"200","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"bfa72383-d67d-4092-b54e-3899689050e4","Process":"Microsoft.Mashup.Container.NetFX40","Pid":10296,"Tid":1,"Duration":"00:00:00.0013676"}

and

"Microsoft.Mashup.Container.NetFX40.13240.2018-06-05T10-21-50-318843.log"
with these lines:

DataMashup.Trace Information: 24579 : {"Start":"2018-06-05T10:21:51.4813506Z","Action":"Engine/IO/Web/Request/GetResponse","HostProcessId":"3736","RequestMethod":"POST","RequestUri":"https://www.myurl.com/servlet/myservlet","RequestHasContent":"True","RequestHasHeaders":"True","RequestHasTimeout":"True","UseCache":"True","ResponseStatusCode":"200","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"d5c53d5d-9a6a-429f-ba46-512831535bae","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13240,"Tid":1,"Duration":"00:00:01.5395413"}
DataMashup.Trace Information: 24579 : {"Start":"2018-06-05T10:21:53.0516059Z","Action":"Engine/IO/Web/Request/GetResponse","HostProcessId":"3736","RequestMethod":"POST","RequestUri":"https://www.myurl.com/servlet/myservlet","RequestHasContent":"True","RequestHasHeaders":"True","RequestHasTimeout":"True","UseCache":"True","ResponseStatusCode":"200","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"d5c53d5d-9a6a-429f-ba46-512831535bae","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13240,"Tid":1,"Duration":"00:00:01.0070358"}

thanks again