cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kewivirus
New Member

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 . It pass the connection test but when I click save IT SHOW ERROR.

 

 Capture.PNG

 

After click save it's show : 

 

Capture2.PNG

6 REPLIES 6
User_PBI
Regular Visitor

Hello,

 

Please do reupload of the .pbix file and configure the data refresh.

I believe there is a corruption in the file that has been uploaded.

 

Thanks.

Hi,

 

Thank you for the answer , But I still got the same problem.

 

How can I find root cause of this error?

It just show that something went wrong I've check Power BI reporting server configuration and nothing happend.

 

I dun know about the source of this error please help.

 

Thanks and wish you all the best.

 

 

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

Hi ganga 2016 MSFT,

 

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

Please see below

 

1 Show error on local time.png

 

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.

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. 

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.

 

evidence.PNG

 

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.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!