Forum Discussion

kewivirus's avatar
kewivirus
New Member
8 years ago

Please help Can't save data source in PBIRS

Hi please help me.   I want to set the Scheduled refresh So I need to set the Stored credentials for the report first, Then I go to the Data Sources page and set the credentials for data source . I...
ganga-2016-MSFT's avatar
ganga-2016-MSFT
Microsoft Employee
8 years ago

Could you please post the error message from the log files after you repro the issue with the exact time stamp. 

  • RSPowerBI_*.log 
  • RSManagement_*.log
  • RSPortal_*.log
  • ReportingServicesService_*.log
kewivirus's avatar
kewivirus
New Member
8 years ago

Hi ganga 2016 MSFT,

 

Thanks for your advice Here is the log and time stamp on my server.

Please see below

 

 

My issue replicate time stamp is 8:55 AM

 

---------------------------RSPowerBI_*.txt----------------------------------

2018-02-12 09:13:31.3050|INFO|58|Started clean up of embedded models
2018-02-12 09:13:31.3050|INFO|58|Finished clean up of 0 embedded models

 

---------------------------RSPowerBI2018_*.txt-----------------------------

2018-02-12 08:54:13.3721|INFO|42|Received request POST /api/checkdatasourceconnection| RequestID = s_250c971f-6365-4406-bb64-a95a015edebc
2018-02-12 08:54:13.3721|INFO|42|CFG : EnableCustomVisuals = [True] (env)
2018-02-12 08:54:13.4858|INFO|42|Sending response. Response code NT AUTHORITY\NETWORK SERVICE 200, Elapsed time 0:00:00.1141571| RequestID = s_250c971f-6365-4406-bb64-a95a015edebc
2018-02-12 08:54:16.8808|INFO|43|Received request POST /api/checkdatasourceconnection| RequestID = s_81ba7afa-78f7-4ca3-ac14-ae56a5559f5b
2018-02-12 08:54:16.8808|INFO|43|CFG : EnableCustomVisuals = [True] (env)
2018-02-12 08:54:16.9078|INFO|43|Sending response. Response code NT AUTHORITY\NETWORK SERVICE 200, Elapsed time 0:00:00.0275549| RequestID = s_81ba7afa-78f7-4ca3-ac14-ae56a5559f5b
2018-02-12 08:58:31.2654|INFO|38|Started clean up of embedded models
2018-02-12 08:58:31.2654|INFO|38|Finished clean up of 0 embedded models

 

---------------------RSPortal_*.txt----------------------------------

RSPortal!reportserverwebapp!RSPortal.exe!c!02/12/2018-08:54:13:: i INFO: Received request POST /api/v2.0/DataSources/Model.CheckConnection | RequestID = s_250c971f-6365-4406-bb64-a95a015edebc
RSPortal!reportserverwebapp!RSPortal.exe!22!02/12/2018-08:54:13:: i INFO: Sending response. Response code Ican'tPublicThisWord 200, Elapsed time 0:00:00.1234401 | RequestID = s_250c971f-6365-4406-bb64-a95a015edebc
RSPortal!reportserverwebapp!RSPortal.exe!c!02/12/2018-08:54:16:: i INFO: Received request POST /api/v2.0/DataSources/Model.CheckConnection | RequestID = s_81ba7afa-78f7-4ca3-ac14-ae56a5559f5b
RSPortal!reportserverwebapp!RSPortal.exe!1b!02/12/2018-08:54:16:: i INFO: Sending response. Response code Ican'tPublicThisWord 200, Elapsed time 0:00:00.0336952 | RequestID = s_81ba7afa-78f7-4ca3-ac14-ae56a5559f5b

 

--------------------ReportingServicesService_*.txt---------------------------------------


library!WindowsService_0!1ba0!02/12/2018-08:52:45:: i INFO: Call to CleanBatch()
library!WindowsService_0!1ba0!02/12/2018-08:52:45:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions, 0 extended content cache.
library!WindowsService_0!1ba0!02/12/2018-08:52:45:: i INFO: Call to CleanBatch() ends
library!WindowsService_0!1af8!02/12/2018-09:02:45:: i INFO: Call to CleanBatch()
library!WindowsService_0!1af8!02/12/2018-09:02:45:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions, 0 extended content cache.
library!WindowsService_0!1af8!02/12/2018-09:02:45:: i INFO: Call to CleanBatch() ends
library!WindowsService_0!740!02/12/2018-09:12:45:: i INFO: Call to CleanBatch()
library!WindowsService_0!740!02/12/2018-09:12:45:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions, 0 extended content cache.
library!WindowsService_0!740!02/12/2018-09:12:45:: i INFO: Call to CleanBatch() ends
library!WindowsService_0!2358!02/12/2018-09:22:45:: i INFO: Call to CleanBatch()
library!WindowsService_0!2358!02/12/2018-09:22:45:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions, 0 extended content cache.
library!WindowsService_0!2358!02/12/2018-09:22:45:: i INFO: Call to CleanBatch() ends

 

-------------------------------RSManagement_*.txt-----------------------------------------

2018-02-12 09:35:50.2423|INFO|1|File Logger created: C:\Program Files\Microsoft Power BI Report Server\PBIRS\Management\RSManagement_2018_02_12_09_35_50.log - level Info, will roll at 32 Mb, process id 9684
2018-02-12 09:35:50.5705|INFO|1|CFG : Dumper.path = [] (env)
2018-02-12 09:35:50.5705|INFO|1|CFG : Name = [] (env)
2018-02-12 09:35:50.5705|INFO|1|CFG : Dumper.flags = [] (env)
2018-02-12 09:35:50.5705|INFO|1|No flag is configured for the Dumper. Using Default settings.
2018-02-12 09:35:50.5705|INFO|1|CFG : Dumper.preventIfContains = [] (env)
2018-02-12 09:35:50.5861|INFO|1|Do not dump on:
2018-02-12 09:35:50.5861|INFO|1|CFG : listenerUrl = [] (env)
2018-02-12 09:35:50.6955|ERROR|1|Unhandled exception in Appdomain System.Collections.Generic.KeyNotFoundException: Missing Configuration [listenerUrl]
at Microsoft.BIServer.HostingEnvironment.StaticConfig.GetOrException(String key)
at Microsoft.BIServer.Management.WebHost.Program.Main(String[] args):
2018-02-12 09:35:50.7424|INFO|1|CFG : rsConfigFilePath = [] (env)
2018-02-12 09:35:50.7424|ERROR|1|Exception thrown while reading configuration: System.Collections.Generic.KeyNotFoundException: Missing Configuration [rsConfigFilePath]
at Microsoft.BIServer.HostingEnvironment.StaticConfig.GetOrException(String key)
at Microsoft.BIServer.Configuration.ConfigReader.get_Current()System.Collections.Generic.KeyNotFoundException: Missing Configuration [rsConfigFilePath]
at Microsoft.BIServer.HostingEnvironment.StaticConfig.GetOrException(String key)
at Microsoft.BIServer.Configuration.ConfigReader.get_Current()

 

 

 

------------------------------------------------------------------------------------

If anything you want to know more for helping me please let me know.

Thanks and wish you all the best.

  • ganga-2016-MSFT's avatar
    ganga-2016-MSFT
    Microsoft Employee
    8 years ago

    Hi kewivirus Thanks for the log files snippet. What is the service account you are running for Power BI report server service? If you are not running on the domain admin user could you try with that.  I am not sure if that helps or not but lets try with that. 

    • kewivirus's avatar
      kewivirus
      New Member
      8 years ago

      Hi ganga-2016-MSFT ,

       

      Thanks for your replied and help me.

      I don't know how to check it but in my understanding; It is a setting in report server configuration right?

       

      I'm try with all service account setting (Network service , Virtual Service account , Domain\user)

      But it still got the same error.

       

       

      I still need to find another way to figureout this problem.

       

      However , Please accept my apologize for any inconveinience.

      And Thanks for all your help :)

       

      Wish you all the best.