Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ASHOKKPIN
Resolver I
Resolver I

Unable to upload desktop created pbix file in New release

When i upload any PBIX (from the same version i got along with PBIRS) with embedded data it errors out.

 

 

Error in Log

2017-11-06 15:50:41.1480|ERROR|35|Failure in reportproperties| RequestID = s_49083c90-e7d9-4b56-bfb9-24f6d3da3ac2 Microsoft.PowerBI.ReportServer.AsServer.AsConnectionException: Failed to connect to AS ---> Microsoft.AnalysisServices.ConnectionException: A connection cannot be made. Ensure that the server is running. ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 127.0.0.1:5132
at System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port)
at Microsoft.AnalysisServices.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)
--- End of inner exception stack trace ---
at Microsoft.AnalysisServices.XmlaClient.OpenConnection(ConnectionInfo connectionInfo, Boolean& isSessionTokenNeeded)
at Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.Core.Server.Connect(String connectionString, String sessionId, ObjectExpansion expansionType)
at Microsoft.AnalysisServices.Core.Server.Connect(String connectionString)
at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesFactory.CreateASWrapper(String serverAddress, Int32 port, TimeSpan timeout)
--- End of inner exception stack trace ---
at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesFactory.CreateASWrapper(String serverAddress, Int32 port, TimeSpan timeout)
at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.<LoadDatabaseAsync>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.ReportServer.WebApi.PBIX.DataModelDataSourceProvider.<RetrieveEmbeddedDataSourcesAsync>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.ReportServer.WebApi.PbiApi.PbiApiController.<ShredWithModel>d__7b.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

1 ACCEPTED SOLUTION
mgmeyer
Power BI Team
Power BI Team

Looks like PBI AS service is not running, can you try to restart the Power BI Report Server service and see if that resolves the issue? Also can you check the log files in the setups LogFiles folder and see if there are any errors, specifically check the msmdsrv.log and RSHostingServiceXXX.log. Thanks!

View solution in original post

6 REPLIES 6
mgmeyer
Power BI Team
Power BI Team

Looks like PBI AS service is not running, can you try to restart the Power BI Report Server service and see if that resolves the issue? Also can you check the log files in the setups LogFiles folder and see if there are any errors, specifically check the msmdsrv.log and RSHostingServiceXXX.log. Thanks!

Cannot start the server in Tabular mode as the needed privilege for memory locking is not held (SE_INC_WORKING_SET_NAME or SE_INC_BASE_PRIORITY_NAME, depending on your operating system version) (Source: \\?\D:\Program Files\PBIRS\PBIRS\LogFiles\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210025

 

Added privileges for the user. It works now!! thanks for the guidance

Ashokkpin, what privileges you added to which user, can you please explain that as i am also facing same issue?

ok you gave this right to the user under which "Power BI" service is running?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.