Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Asma REZGUI]

Hello PUG,

I have created 3 servers on wich I have installed : PowerBI Report Server, SSAS and SQL Server.
I have configured Kerberos.
However, it is not working

We couldn’t run the report because we couldn’t connect to its data source. The report or data source might not be configured correctly.
Please try again later or contact support. If you contact support, please provide these details.

We couldn’t connect to the Analysis Services server. The server forcibly closed the connection. To connect as the user viewing the report, your organization must have configured Kerberos constrained delegation.

Request ID9115842d-13ca-19f4-da04-93a824f9e0b8
TimeWed Feb 21 2018 17:12:06 GMT+0100 (Romance Standard Time)
Version14.0.600.442

in log files :

2018-02-21 17:12:06.1462|ERROR|10|PBI.Win.ReportingServicesHostTrace|type:Error;message:processing:Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source ‘EntityDataSource’. —> Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: The connection either timed out or was lost. —> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. —> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host
   at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   — End of inner exception stack trace —
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
   at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length)
   at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ReadHeader()
   at Microsoft.AnalysisServices.AdomdClient.DimeReader.ReadRecord()
   at Microsoft.AnalysisServices.AdomdClient.TcpStream.GetResponseDataType()
   — End of inner exception stack trace —
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.EndRequest(Boolean useBinaryXml)
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.SendMessage(Boolean endReceivalIfException, Boolean readSession, Boolean readNamespaceCompatibility)
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.SupportsProperty(String propName)
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
   at Microsoft.ReportingServices.DataExtensions.AdomdExceptionHandler.Execute(String connectionString, Action action)
   at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.<>c__DisplayClass6_0.<OpenConnection>b__0()
   — End of inner exception stack trace —;;| RequestID = 9115842d-13ca-19f4-da04-93a824f9e0b8 ClientSessionID = 3a233905-497b-a82c-314a-77608064f6ae
2018-02-21 17:12:06.1618|ERROR|10|PBI.Win.ProcessingError|ExceptionType:Microsoft.ReportingServices.ReportProcessing.ReportProcessingException;stackTrace:   at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.<>c__DisplayClass6_0.<OpenConnection>b__0()
   at Microsoft.ReportingServices.Diagnostics.Utilities.DefaultActivitiesFactory.CreateSyncActivityAndReportResult(RSActivityType activityType, Action action)
   at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.<>c__DisplayClass5_0.<OpenDataSourceExtensionConnection>b__0()
   at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.HandleImpersonation(IProcessingDataSource dataSource, DataSourceInfo dataSourceInfo, String datasetName, IDbConnection connection, Action afterImpersonationAction)
   at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.OpenDataSourceExtensionConnection(IProcessingDataSource dataSourceObj, String connectString, DataSourceInfo dataSourceInfo, String datasetName)
   at Microsoft.PowerBI.ReportingServicesHost.LocalDataExtensionConnectionWrapper..ctor(DataSourceInfo dataSourceInfo, CreateDataExtensionInstance createExtensionCallback, UserContext threadUser, ExecutionType execType, IAdditionalToken additionalToken, IDbConnectionPool connectionPool, IDataProtection dataProtection)
   at Microsoft.PowerBI.ReportingServicesHost.LocalDataExtensionConnectionWrapper.<>c__DisplayClass7_0.<Open>b__0()
   at Microsoft.PowerBI.ReportServer.ExploreHost.WindowsUserIdentityConnectionImpersonator.ExecuteInContext[T](Func`1 func)
   at Microsoft.PowerBI.ReportingServicesHost.LocalReportProcessingHost.GetModelMetadata(DataSourceInfo dataSourceInfo, IDbConnectionPool connectionPool, String modelMetadataVersion, IConnectionUserImpersonator connectionUserImpersonator, ITelemetryService telemetryService)
   at Microsoft.PowerBI.ReportingServicesHost.DataShapingHelper.GetModelMetadata(IPowerViewEngine powerViewEngine, IDbConnectionPool connectionPool, DataSourceInfo dataSourceInfo, IASConnectionInfo asConnectionInfo, Boolean useMsolapForCsdl, IConnectionUserImpersonator connectionUserImpersonator, ITelemetryService telemetryService, String maxModelMetadataVersion);message:GetModelAsStream;| RequestID = 9115842d-13ca-19f4-da04-93a824f9e0b8 ClientSessionID = 3a233905-497b-a82c-314a-77608064f6ae
2018-02-21 17:12:06.1774|ERROR|4|Failure in conceptualschema| RequestID = 9115842d-13ca-19f4-da04-93a824f9e0b8 ClientSessionID = 3a233905-497b-a82c-314a-77608064f6ae Microsoft.PowerBI.ReportServer.ExploreHost.Error.RSExploreHostException: Cannot create a connection to data source ‘EntityDataSource’. —> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source ‘EntityDataSource’. —> Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: The connection either timed out or was lost. —> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. —> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host
   at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   — End of inner exception stack trace —
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
   at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length)
   at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ReadHeader()
   at Microsoft.AnalysisServices.AdomdClient.DimeReader.ReadRecord()
   at Microsoft.AnalysisServices.AdomdClient.TcpStream.GetResponseDataType()
   — End of inner exception stack trace —
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.EndRequest(Boolean useBinaryXml)
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.SendMessage(Boolean endReceivalIfException, Boolean readSession, Boolean readNamespaceCompatibility)
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.SupportsProperty(String propName)
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
   at Microsoft.ReportingServices.DataExtensions.AdomdExceptionHandler.Execute(String connectionString, Action action)
   at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.<>c__DisplayClass6_0.<OpenConnection>b__0()

Any idea please?
Regards,
 

This e-mail is sent by the above named in their individual, non-business capacity and is not on behalf of PricewaterhouseCoopers, Société coopérative, Luxembourg.  PricewaterhouseCoopers, Société coopérative, Luxembourg, cannot be held liable for the information contained in this e-mail.
MiFID II Certification | PwC’s Academy accredited training provider to comply with the circular CSSF 17/665

---

Unless otherwise stated, the content of this e-mail and any attachments does not represent the formal opinion of PwC (this only being included in an audit report or other “final deliverable” work products). The content is provided in accordance with the understanding of PwC of current Luxembourg laws, regulations, professional or accounting standards, and practice in Luxembourg at the date of this communication/document, and is not binding on any Luxembourg authorities, regulators, or court. The content is based upon the information that you and/or your representatives have provided us with or given us access to, and interpretation may vary in the event of changes in facts or the regulatory environment. For the sake of clarity, please refer to the engagement letter signed between both our organizations to understand fully our respective commitments, rights, and obligations.

The information transmitted is intended only for the person or entity to which it is addressed, and may contain confidential and/or privileged material. Any review, re-transmission, dissemination or other use of, or the taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this e-mail in error, please contact the sender, and delete the material from any computer.

[Hasham Niaz]

Hi,

You need to provide some more information;

Did you develop your reports using Power BI Desktop (Optimized for PBI Report Server)
When developing reports, what is your Data Source SSAS or SQL Server
Also what is your method for connecting to Data Source, SQL User or Windows Authentication

When you published your report to Power BI Report Server, does it publish successfully
Please check your report through Power BI Report Manager URL, click on edit report, it will show you Data source used for your report
Try correcting the credentials in Data Source and refreshing report

——————————
Hasham Niaz
Sr. BI Consultant
Karachi, Pakistan
——————————
——————————————-

[Asma REZGUI]

?HEllo,

Yes reports are using PBI DEsktop for Report Server.
SSAS Datasource
I use : As the user viewing the report  because security is managed in the cube side
PowerBI Report SErver is on server 1 in VLAN1
SSAS is on server2 on VLAN2
SQL Server is on server3 on VLAN3
Ports are opened and on my local server i can connect to dashborad.
Once I launch url from an external browser I got a kerberos error.
May be I should open kerberos ports to let it communicate between PowerBI and SSAS?

Reports work properly in local server.

Many thanks
Asma

——————————
Asma REZGUI
Application Administrator
PwC EMEA
621421558
——————————
——————————————-

[Craig Humphrey]

Hi,

can I suggest, for testing purposes, you start with all three servers on the same VLAN (so that you don’t have to bridge the VLANs) and with the firewalls off.
Then use a basic SSRS style report, that just connects to a SQL DB – and use that to confirm you’re getting kerberos.
Then step that up to connect SSRS to SSAS – again, keep an eye on kerberos (you’re using the kerbtray and other tools right?)
And you know how to set up all the SPNs and delegation right?
Then step that up to use a PowerBI report to connect to SSAS, still keeping an eye on kerberos.
Then lock down your firewall – leaving the various SQL ports open, along with the kerberos ones (probably AD too:
https://technet.microsoft.com/en-us/library/bb125069(v=exchg.65).aspx
)
And if that still works, then split the servers out over your separate VLANs, ensuring you’re bridging (and potentially routing) between the VLANs as necessary.

Hope that helps.

The SQL Kerberos config tool can sometimes help:
Microsoft® Kerberos Configuration Manager for SQL Server®

Thanks
Craig——————————————-

[Hasham Niaz]

Hi,

Lets track this down step by step;

So you can access the Dashboard / Report using PBI Report Server URL form your local machine ?
If this is correct, then probably you need to figure more into your VLAN & kerberos.

Also when you go to Power BI Report Server configuration manager, you have option for setting up external URL & custom ports

See if you can access both internal & external URL from your local machine.

Are you using nay static IP for your external URL please let us know.

Another case study which you can do is to create a .pbix report with SQL Server as DS on your local machine and use SQL Authentication for DS.

Try publishing it on PBI Report Server & configure the DS from PBI Report Manage URL by edit report option.

See if you can access .pbix from PBI Report Server & Report Manager URL for SQL DS.

——————————
Hasham Niaz
Sr. BI Consultant
Karachi, Pakistan
——————————
——————————————-

[Hasham Niaz]

Also did you read the consideration / recommendation for setting up PBI Report Server;

Avoiding Kerberos

There are two ways to avoid Kerberos.

Option 1. Install Power BI Report Server on the same machine as SSAS Tabular and build all of your reports using tabular models on this same machine.

Option 2. After saving your report to the Power BI Report Server click on Manage the report and then Data Sources. Enter in Credentials that can access the data sources used int the Power BI Report.

——————————
Hasham Niaz
Sr. BI Consultant
Karachi, Pakistan
——————————
——————————————-