topic Re: Unable to Save to PowerBI Reporting Server in Report Server

Unable to Save to PowerBI Reporting Server

cragland — Sun, 29 Apr 2018 17:44:52 GMT

I'm new to PowerBI but have been a SQL Server DBA for years. We just got through POC of PowerBI and are trying to get this into a Dev environment. We are unable to load reports either through the Save As to a PowerBI Report Server or Upload directly from the site as mentioned in multiple posts.

Installations:

Windows Server 2012

PowerBI Report Server: 14.0.600.442

PowerBI Desktop: 2.56.5023.1043 64-bit (March 2018)

Reading through other blogs. I made sure that we only have the PowerBI Reporting Server installed. The Service Account running PowerBI is part of the local admin group. I'm part of the local admin group of the server. Both accounts are sa within SQL Server. I originally attempted from my laptop. When I couldn't find an error, I installed PowerBI Desktop directly on the server. I can't seem to find an error through the logs I've looked into. I'm new and baffled! Below are the contents of the areas discussed.

I enabled diagnostics and went through the PowerBI Trace Performance Logs:

PBIDesktop

Microsoft.Mashup.Container

FrownSnapshot:

There were two files a json and SQL Profiler, but no log?

PerformanceTraces.Zip:

SimpleDocumentEvaluator/GetResult/Compile {"Start":"2018-04-28T15:56:03.8863953Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","HostProcessId":"7608","ProductVersion":"2.56.5023.1043 (PBIDesktop)","ActivityId":"f59b30dd-536a-4f10-8d2a-ecfcb7800178","Process":"Microsoft.Mashup.Container.NetFX40","Pid":2320,"Tid":1,"Duration":"00:00:01.3095694"}
SimpleDocumentEvaluator/GetResult/Evaluate {"Start":"2018-04-28T15:56:05.1960484Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","HostProcessId":"7608","ProductVersion":"2.56.5023.1043 (PBIDesktop)","ActivityId":"f59b30dd-536a-4f10-8d2a-ecfcb7800178","Process":"Microsoft.Mashup.Container.NetFX40","Pid":2320,"Tid":1,"Duration":"00:00:01.2000329"}
SimpleDocumentEvaluator/GetResult<IPreviewValueSource> {"Start":"2018-04-28T15:56:03.8762512Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","HostProcessId":"7608","ProductVersion":"2.56.5023.1043 (PBIDesktop)","ActivityId":"f59b30dd-536a-4f10-8d2a-ecfcb7800178","Process":"Microsoft.Mashup.Container.NetFX40","Pid":2320,"Tid":1,"Duration":"00:00:02.8346304"}
FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-04-28T15:56:03.6196676Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"7608","ProductVersion":"2.56.5023.1043 (PBIDesktop)","ActivityId":"f59b30dd-536a-4f10-8d2a-ecfcb7800178","Process":"Microsoft.Mashup.Container.NetFX40","Pid":2320,"Tid":1,"Duration":"00:00:02.7806341"}
SimpleDocumentEvaluator/GetResult/Compile {"Start":"2018-04-28T15:56:06.8369098Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","HostProcessId":"7608","ProductVersion":"2.56.5023.1043 (PBIDesktop)","ActivityId":"ce005836-382a-4759-a41c-d6992a2fb70b","Process":"Microsoft.Mashup.Container.NetFX40","Pid":2320,"Tid":1,"Duration":"00:00:00.0052268"}
SimpleDocumentEvaluator/GetResult/Evaluate {"Start":"2018-04-28T15:56:06.8421828Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","HostProcessId":"7608","ProductVersion":"2.56.5023.1043 (PBIDesktop)","ActivityId":"ce005836-382a-4759-a41c-d6992a2fb70b","Process":"Microsoft.Mashup.Container.NetFX40","Pid":2320,"Tid":1,"Duration":"00:00:00.1017820"}
SimpleDocumentEvaluator/GetResult<IPreviewValueSource> {"Start":"2018-04-28T15:56:06.8368826Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","HostProcessId":"7608","ProductVersion":"2.56.5023.1043 (PBIDesktop)","ActivityId":"ce005836-382a-4759-a41c-d6992a2fb70b","Process":"Microsoft.Mashup.Container.NetFX40","Pid":2320,"Tid":1,"Duration":"00:00:00.1075471"}
FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-04-28T15:56:06.8354404Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"7608","ProductVersion":"2.56.5023.1043 (PBIDesktop)","ActivityId":"ce005836-382a-4759-a41c-d6992a2fb70b","Process":"Microsoft.Mashup.Container.NetFX40","Pid":2320,"Tid":1,"Duration":"00:00:00.1086121"}
SimpleDocumentEvaluator/GetResult/Compile {"Start":"2018-04-28T15:56:09.1500498Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","HostProcessId":"7608","ProductVersion":"2.56.5023.1043 (PBIDesktop)","ActivityId":"f59b30dd-536a-4f10-8d2a-ecfcb7800178","Process":"Microsoft.Mashup.Container.NetFX40","Pid":2320,"Tid":1,"Duration":"00:00:00.0068137"}
SimpleDocumentEvaluator/GetResult/Evaluate {"Start":"2018-04-28T15:56:09.1569230Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","HostProcessId":"7608","ProductVersion":"2.56.5023.1043 (PBIDesktop)","ActivityId":"f59b30dd-536a-4f10-8d2a-ecfcb7800178","Process":"Microsoft.Mashup.Container.NetFX40","Pid":2320,"Tid":1,"Duration":"00:00:00.0114087"}
SimpleDocumentEvaluator/GetResult<IPreviewValueSource> {"Start":"2018-04-28T15:56:09.1500303Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","HostProcessId":"7608","ProductVersion":"2.56.5023.1043 (PBIDesktop)","ActivityId":"f59b30dd-536a-4f10-8d2a-ecfcb7800178","Process":"Microsoft.Mashup.Container.NetFX40","Pid":2320,"Tid":1,"Duration":"00:00:00.1667810"}
FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-04-28T15:56:09.1492425Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"7608","ProductVersion":"2.56.5023.1043 (PBIDesktop)","ActivityId":"f59b30dd-536a-4f10-8d2a-ecfcb7800178","Process":"Microsoft.Mashup.Container.NetFX40","Pid":2320,"Tid":1,"Duration":"00:00:00.0191359"}
SimpleDocumentEvaluator/GetResult/Compile {"Start":"2018-04-28T15:56:09.3341227Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","HostProcessId":"7608","ProductVersion":"2.56.5023.1043 (PBIDesktop)","ActivityId":"f59b30dd-536a-4f10-8d2a-ecfcb7800178","Process":"Microsoft.Mashup.Container.NetFX40","Pid":2320,"Tid":1,"Duration":"00:00:00.0057800"}
SimpleDocumentEvaluator/GetResult/Evaluate {"Start":"2018-04-28T15:56:09.3399561Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","HostProcessId":"7608","ProductVersion":"2.56.5023.1043 (PBIDesktop)","ActivityId":"f59b30dd-536a-4f10-8d2a-ecfcb7800178","Process":"Microsoft.Mashup.Container.NetFX40","Pid":2320,"Tid":1,"Duration":"00:00:00.0089739"}
SimpleDocumentEvaluator/GetResult<IPreviewValueSource> {"Start":"2018-04-28T15:56:09.3340981Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","HostProcessId":"7608","ProductVersion":"2.56.5023.1043 (PBIDesktop)","ActivityId":"f59b30dd-536a-4f10-8d2a-ecfcb7800178","Process":"Microsoft.Mashup.Container.NetFX40","Pid":2320,"Tid":1,"Duration":"00:00:00.0359982"}
FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2018-04-28T15:56:09.3333046Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"7608","ProductVersion":"2.56.5023.1043 (PBIDesktop)","ActivityId":"f59b30dd-536a-4f10-8d2a-ecfcb7800178","Process":"Microsoft.Mashup.Container.NetFX40","Pid":2320,"Tid":1,"Duration":"00:00:00.0156757"}

Below is a diagnostic snapshot:

Feedback Type:
Frown (Error)

Timestamp:
2018-04-29T17:21:36.5872797Z

Local Time:
2018-04-29T12:21:36.5872797-05:00

Session ID:
6ee1d4ff-372c-47f9-a59c-aa0f1ff32b9f

Release:
March 2018

Product Version:
2.56.5023.1043 (PBIDesktop) (x64)

OS Version:
Microsoft Windows NT 6.3.9600.0 (x64 en-US)

CLR Version:
4.6.1 or later [Release Number = 394271]

Peak Virtual Memory:
33.7 GB

Private Memory:
249 MB

Peak Working Set:
395 MB

IE Version:
11.0.9600.18978

User ID:
869f5f6a-c779-4512-9b60-333062483fef

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\Profile\AppData\Local\Microsoft\Power BI Desktop SSRS\FrownSnapShot1367478200.zip

Performance Trace Logs:
C:\Users\Profile\AppData\Local\Microsoft\Power BI Desktop SSRS\PerformanceTraces.zip

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
CustomConnectors
PBI_AdobeAnalytics
PBI_qnaExplore
PBI_variationUIChange
PBI_customVisualsGallery
PBI_canvasTooltips

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
150%

Supported Services:
Power BI Report Server, Power BI

Formulas:

section Section1;

shared Data = let
    Source = Excel.Workbook(File.Contents("E:\Team Statistics\Changes.xlsx"), null, true),
    Data_Sheet = Source{[Item="Data",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Data_Sheet, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"#", Int64.Type}, {"CAB Date", type datetime}, {"Status", type text}, {"Type", type text}, {"Category", type text}, {"Subject", type text}, {"Requestor", type text}, {"Team", type text}, {"Closed On", type datetime}, {"Start", type datetime}, {"Created On", type datetime}, {"End", type datetime}})
in
    #"Changed Type";

Re: Unable to Save to PowerBI Reporting Server

Anonymous — Mon, 30 Apr 2018 14:42:40 GMT

Hey cragland,

We are currently having the same issue on our Prod server even though our Dev and Test have no issues.

You should be able to find the fix HERE. (Basically put the service account running Power BI in the local admin group on the server) We are currently waiting on our corporate AD people to make the change for us. I hope this helps.

Re: Unable to Save to PowerBI Reporting Server

cragland — Mon, 30 Apr 2018 16:44:14 GMT

Jasel,

Thank you for your response, I had already done that which at this point makes no sense why it wouldn't work.

Re: Unable to Save to PowerBI Reporting Server

Anonymous — Tue, 01 May 2018 09:21:42 GMT

Hi Jasel,

Just wondering...

What error message do you get in PBI Desktop?

Did publishing from the PBI Desktop installation on the server work?

Is the PBI Report Server portal running and accessible from a web browser?

Have you configured permissions within the PBI Report Server portal allowing people to publish reports?

Re: Unable to Save to PowerBI Reporting Server

Anonymous — Tue, 01 May 2018 13:52:27 GMT

Anonymous - I'll post my issue in a seperate thread so we don't hijack this one.

Re: Unable to Save to PowerBI Reporting Server

Anonymous — Tue, 01 May 2018 14:28:17 GMT

Jasel - apologies the questions were actually meant for the post owner (sorry it was early when I replied!!).

Re: Unable to Save to PowerBI Reporting Server

cragland — Tue, 01 May 2018 17:14:31 GMT

Hi Jasel,

I changed the credentials to my elevated for our environment just to see if we could get past the errors. The PowerBI Report Server is set up and using my elevated credentials right now. I'm an administrator on the server and within SQL Server. The report I'm trying to publish has multiple tabs using spreadsheets. When I began having issues, I moved everything onto the server just to remove having to go through the environment to publish. I made sure to change the path to the drive the spreadsheets now reside on.

save as to the report server: An error occurred while attempting to save the rport to Power BI report server

upload from the web page: There was an error uploading your .pbix file. Verify that the file has not be corrupted and that the file extension matches the format of the file.

Re: Unable to Save to PowerBI Reporting Server

jayjay1 — Mon, 06 Aug 2018 15:58:25 GMT

Hi,

I was getting the "An error occured while attempting to save the report to Power BI Report Server" error message when trying to publish my PBI reports to PBI Report Server. However, when I downgraded my PBI desktop (optimised for Report Server) to match the Report Server version so in my case uninstalling my desktop version (March 2018) then installing Oct 2017) this did the trick and I was able to publish successfully without any issues.

The other option is to obviously upgrade the Report Server to the latest version (or to match your desktop version) but this should be tested first on non-production systems and it's easier to test locally first before messing with servers.

Hope this helps,

Jay

Re: Unable to Save to PowerBI Reporting Server

Anonymous — Tue, 14 Aug 2018 19:47:04 GMT

I had similar issue when I installed March 2018 on our Dev server, Production was still running Oct 2017 version. I was able to install Desktop RS March 2018 version along while leaving the Oct 2017 RS Desktop version. Tricky part is specifying different folders for each installation, this allows you to have multiple RS versions, and at least 1 Service version. If you try to use one Desktop RS version to save to a Power BI Report server with a different version you will get errors like the ones in the original question on this post.