cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TheSmilingDBA Frequent Visitor
Frequent Visitor

An error occurred while attempting to save the report to Power BI Report Server

We installed Power BI Report Server (Octobet 2017) from Enterprise license with SA (we have an EA). The existing report server was SQL Server 2014 Enterprise with many rdl files loaded. The Report Server was upgraded first while SQL Server 2014 Enterprise database engine was not upgraded. The reports ran fine but we never tested Power BI Reports.

 

After upgrading the database engine, SSAS and SSIS to 2017 Enterprise, the first Power BI report we tried to save got the following error:

 

An error occurred while attempting to save the report to Power BI Report Server. (close and cancel buttons)

 

The report is saved on the portal and can run on the portal if the data was imported. If a new Power BI report has a live connection to SSAS, no data is displayed.

 

The service is being run by an AD account that has local admin on the server. No virtual account or NETWORK SERVICE account is being used.

 

here are some log file:

 

RSManagement_yyy_mm_dd_hh_dd_ss.log

2018-03-20 08:53:39.1643|ERROR|13|One or more errors occurred.| RequestID = s_6c234c92-31b5-4a81-a174-f721f2905a42
2018-03-20 08:53:49.2080|ERROR|6|One or more errors occurred.| RequestID = s_f0e96508-f53f-4a92-a2cd-fe9a88a56b8d
2018-03-20 08:53:59.2547|ERROR|18|One or more errors occurred.| RequestID = s_88d77243-0a06-4d9d-beda-687130cbb993
2018-03-20 08:54:09.2984|ERROR|5|One or more errors occurred.| RequestID = s_0ac936da-c7f8-4774-90a9-e13cd107aed6
2018-03-20 08:54:19.3501|ERROR|6|One or more errors occurred.| RequestID = s_c0a71b9f-b928-4f61-ae42-7d8eb1921838
2018-03-20 08:54:29.3948|ERROR|7|One or more errors occurred.| RequestID = s_93b7f9ca-75ee-4b9e-b2cf-a347a425cd3c
2018-03-20 08:54:39.4436|ERROR|5|One or more errors occurred.| RequestID = s_aa56adff-bb1f-40fe-9649-8b3c733ea6a4
2018-03-20 08:54:49.4863|ERROR|14|One or more errors occurred.| RequestID = s_163ac7d8-d7bd-426b-b166-201805170293
2018-03-20 08:54:59.5350|ERROR|7|One or more errors occurred.| RequestID = s_03b24338-6c33-4ffc-b328-28fef2f304cf
2018-03-20 08:55:09.5797|ERROR|13|One or more errors occurred.| RequestID = s_deb6afa8-b16f-4a13-9f8f-d264b85140aa
2018-03-20 08:55:19.6254|ERROR|7|One or more errors occurred.| RequestID = s_798b82c8-aaa9-4a57-8bcf-27a7ed030a2d
2018-03-20 08:55:29.6691|ERROR|5|One or more errors occurred.| RequestID = s_f506acd5-7217-487f-9337-b7657653a933

 

RSPowerBI_yyy_mm_dd_hh_mm_ss.log

 

2018-03-20 08:05:14.1186|INFO|4|Started clean up of embedded models
2018-03-20 08:05:14.1186|INFO|4|Finished clean up of 0 embedded models
2018-03-20 08:20:14.1322|INFO|4|Started clean up of embedded models
2018-03-20 08:20:14.1322|INFO|4|Finished clean up of 0 embedded models
2018-03-20 08:35:14.1457|INFO|17|Started clean up of embedded models
2018-03-20 08:35:14.1457|INFO|17|Finished clean up of 0 embedded models
2018-03-20 08:47:34.8125|INFO|12|Received request POST /api/reportpropertiesfromlocalfiles| RequestID = s_b7223224-7dbd-4760-8241-ad5a3730da53
2018-03-20 08:47:34.8125|INFO|12|CFG : EnableCustomVisuals = [True] (env)
2018-03-20 08:47:38.1647|INFO|14|Sending response. Response code DOMAIN\sadmin 200, Elapsed time 0:00:03.3529771| RequestID = s_b7223224-7dbd-4760-8241-ad5a3730da53
2018-03-20 08:47:52.0224|INFO|8|Received request GET /| RequestID = s_3e12d0d8-8aa1-4d60-ac38-52643cc5a3d6
2018-03-20 08:47:53.8252|INFO|8|Received request GET /api/explore/reports/291522a3-fd64-4ef9-ab4f-0ae2b6859f8b/modelsAndExploration| RequestID = 96d05d7c-e103-f8ee-a811-364685c999c5 ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703
2018-03-20 08:47:53.8252|INFO|8|CFG : EnableCustomVisuals = [True] (env)
2018-03-20 08:47:57.6018|INFO|14|CFG : EnableCustomVisuals = [True] (env)
2018-03-20 08:47:57.6018|INFO|14|CFG : EnablePowerBIReportExportData = [True] (env)
2018-03-20 08:47:57.6330|INFO|17|Sending response. Response code domain\tadmin 200, Elapsed time 0:00:03.810953| RequestID = 96d05d7c-e103-f8ee-a811-364685c999c5 ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703
2018-03-20 08:47:57.6957|INFO|8|Received request POST /api/explore/reports/291522a3-fd64-4ef9-ab4f-0ae2b6859f8b/conceptualschema| RequestID = bc6b3e5d-271c-4090-4a49-733f9050b01b ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703
2018-03-20 08:47:57.6957|INFO|8|CFG : EnableCustomVisuals = [True] (env)
2018-03-20 08:47:58.9163|INFO|4|Sending response. Response code domain\tadmin 200, Elapsed time 0:00:01.2335013| RequestID = bc6b3e5d-271c-4090-4a49-733f9050b01b ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703
2018-03-20 08:47:59.0441|INFO|18|Received request POST /api/explore/reports/291522a3-fd64-4ef9-ab4f-0ae2b6859f8b/querydata| RequestID = f76d2547-6444-c30c-d48e-22fe78a3ded0 ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703
2018-03-20 08:47:59.0441|INFO|18|CFG : EnableCustomVisuals = [True] (env)
2018-03-20 08:47:59.0441|INFO|8|Received request POST /api/explore/reports/291522a3-fd64-4ef9-ab4f-0ae2b6859f8b/querydata| RequestID = 8e983200-cf01-7207-20c7-a24d49a0290a ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703
2018-03-20 08:47:59.0441|INFO|8|CFG : EnableCustomVisuals = [True] (env)
2018-03-20 08:47:59.0441|INFO|12|Received request POST /api/explore/reports/291522a3-fd64-4ef9-ab4f-0ae2b6859f8b/querydata| RequestID = dedd4dc9-6f55-aea1-fb7c-c495b354ddbb ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703
2018-03-20 08:47:59.0441|INFO|12|CFG : EnableCustomVisuals = [True] (env)
2018-03-20 08:47:59.2687|INFO|19|PBI.DS.HostTrace|type:Information;message:Generating DataShape for: D2021183B2EA5DC34D5CBE97B8CA47D0BB71801F07293D198FADEB2E4345D3EE;| RequestID = 8e983200-cf01-7207-20c7-a24d49a0290a ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703
2018-03-20 08:47:59.2843|INFO|14|PBI.DS.HostTrace|type:Information;message:Generating DataShape for: 303715754C0CB3A08E2C917A5CBB8E3773A736A554065A8BD18690F0E7BBCB85;| RequestID = f76d2547-6444-c30c-d48e-22fe78a3ded0 ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703
2018-03-20 08:47:59.2843|INFO|5|PBI.DS.HostTrace|type:Information;message:Generating DataShape for: D43658CC071B91F15536072E102E09FFD900F750B073C4321F246A5E259B0138;| RequestID = dedd4dc9-6f55-aea1-fb7c-c495b354ddbb ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703
2018-03-20 08:47:59.3000|INFO|19|PBI.DS.HostTrace|type:Information;messageSmiley Very HappySQGen Telemetry: {"NumSelects":1};| RequestID = 8e983200-cf01-7207-20c7-a24d49a0290a ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703
2018-03-20 08:47:59.3000|INFO|14|PBI.DS.HostTrace|type:Information;messageSmiley Very HappySQGen Telemetry: {"NumSelects":1};| RequestID = f76d2547-6444-c30c-d48e-22fe78a3ded0 ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703
2018-03-20 08:47:59.3000|INFO|5|PBI.DS.HostTrace|type:Information;messageSmiley Very HappySQGen Telemetry: {"NumSelects":3};| RequestID = dedd4dc9-6f55-aea1-fb7c-c495b354ddbb ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703
2018-03-20 08:47:59.3625|INFO|14|PBI.DS.HostTrace|type:Information;message:QueryPattern: SuperDax;| RequestID = f76d2547-6444-c30c-d48e-22fe78a3ded0 ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703
2018-03-20 08:47:59.3937|INFO|19|PBI.DS.HostTrace|type:Information;message:QueryPattern: SuperDax;| RequestID = 8e983200-cf01-7207-20c7-a24d49a0290a ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703
2018-03-20 08:47:59.3937|INFO|5|PBI.DS.HostTrace|type:Information;message:QueryPattern: SuperDax;| RequestID = dedd4dc9-6f55-aea1-fb7c-c495b354ddbb ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703
2018-03-20 08:47:59.6437|INFO|5|PBI.DS.HostTrace|type:Information;message:Running the query. Memory Limit=0, Timeout=0, RequestPriority=Normal, ConnectionCategory=External, Query=6E239A294E07E8E174E6B64891A70E90E4301A667BF76CBA2A8DE50BFC368287;| RequestID = dedd4dc9-6f55-aea1-fb7c-c495b354ddbb ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703
2018-03-20 08:47:59.6437|INFO|19|PBI.DS.HostTrace|type:Information;message:Running the query. Memory Limit=0, Timeout=0, RequestPriority=Normal, ConnectionCategory=External, Query=DAA00E93F4B283A2A4273016FC80A112D2A20D6074739E86F3ADACC98975C289;| RequestID = 8e983200-cf01-7207-20c7-a24d49a0290a ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703
2018-03-20 08:47:59.6437|INFO|14|PBI.DS.HostTrace|type:Information;message:Running the query. Memory Limit=0, Timeout=0, RequestPriority=Normal, ConnectionCategory=External, Query=B6062D1A63EBBDABEDC90CE92EA7880D0BD5AD594ECD068C4CF5273BF307BDC5;| RequestID = f76d2547-6444-c30c-d48e-22fe78a3ded0 ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703
2018-03-20 08:47:59.8000|INFO|5|Sending response. Response code domain\tadmin 200, Elapsed time 0:00:00.7445504| RequestID = 8e983200-cf01-7207-20c7-a24d49a0290a ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703
2018-03-20 08:47:59.8000|INFO|5|Sending response. Response code domain\tadmin 200, Elapsed time 0:00:00.7593658| RequestID = f76d2547-6444-c30c-d48e-22fe78a3ded0 ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703
2018-03-20 08:47:59.8000|INFO|15|Sending response. Response code domain\tadmin 200, Elapsed time 0:00:00.7468726| RequestID = dedd4dc9-6f55-aea1-fb7c-c495b354ddbb ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703
2018-03-20 08:50:14.1659|INFO|17|Started clean up of embedded models
2018-03-20 08:50:14.1899|INFO|17|Finished clean up of 0 embedded models
2018-03-20 08:50:19.3613|INFO|31|Received request POST /api/reportpropertiesfromlocalfiles| RequestID = s_08795e4e-57aa-4112-acad-a145889de0f7
2018-03-20 08:50:19.3613|INFO|31|CFG : EnableCustomVisuals = [True] (env)
2018-03-20 08:50:22.5975|INFO|32|Sending response. Response code domain\sqluser 200, Elapsed time 0:00:03.2358909| RequestID = s_08795e4e-57aa-4112-acad-a145889de0f7