Forum Discussion

dusilmenni's avatar
dusilmenni
Regular Visitor
8 years ago

PowerBI Reports in SharePoint 2016 webpart

Hi everyone. I have a rather weird problem regarding the SharePoint webpart for paginated reports in PowerBI. After adding the webpart and configuring it to show a report from the powerbi server, i...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi dusilmenni,

 

Unfortunately, if there is no information in either SharePoint or RS logs, then I think that means that you'll have to capture the traffic from SharePoint to RS using a tool like Fiddler. Hopefully, you'll find a request that failed in there that will help us out in determining where the problem might lie.

 

- Jason

dusilmenni's avatar
dusilmenni
Regular Visitor
8 years ago

Hi Jason.

I´m not sure what the problem is but I can see that must have something to do with the authentication.

This is a trace when everything is working in my webpart, until a browser refresh at line 53.

At that point it doesnt get any response header with the authentication ticket.

 

POST https://powerbiextended.DOMAIN.IS:443/reportserver/ReportExecution2005.asmx HTTP/1.1
Accept-Language: en-US
User-Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 10.0; WOW64; Trident/7.0; Touch; .NET4.0C; .NET4.0E; .NET CLR 2.0.50727; .NET CLR 3.0.30729; .NET CLR 3.5.30729)
Content-Type: text/xml; charset=utf-8
SOAPAction: "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListSecureMethods"
Host: powerbiextended.DOMAIN.is:443
Content-Length: 353
Expect: 100-continue

<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><ListSecureMethods xmlns="http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices" /></soap:Body></soap:Envelope>

 

This is the call at line 53 and below.

Any ideas?