Forum Discussion

cragland's avatar
cragland
Regular Visitor
8 years ago

Unable to Save to PowerBI Reporting Server

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";

 

 

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.

    • cragland's avatar
      cragland
      Regular Visitor

      Jasel,

       

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

      • Anonymous's avatar
        Anonymous
        Not applicable

        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?

  • jayjay1's avatar
    jayjay1
    Frequent Visitor

    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

    • Anonymous's avatar
      Anonymous
      Not applicable

      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.