Forum Discussion

shamsuddeenvp's avatar
shamsuddeenvp
Icon for Post Patron rankPost Patron
9 years ago

Power BI Report server - Issue with deploying power bi report

Dear,

 

I am trying Power BI Report server, configuration done and able to access the report server urla s well.

 

However when I try to save/deploy the pbix file into the server I am getting the below error

"an error while attempting to save the report to power bi" Please find below the atatched screenshots as well.

 

BR,

Shams

 

48 Replies

  • AFo's avatar
    AFo
    Frequent Visitor

    Hi v-qiuyu-msft,

     

    Adding the service account NT SERVICE\PowerBIReportServer as a local admin on the server has resolved the issue for me and I can now upload Power BI reports to the report server.

     

    Normal SSRS reports upload fine without this permission but PBI reports will not. Maybe something missing from installation that assigns the required permission to the service account?

     

    Thanks for following this up with the escalation engineer.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi all,

     

    we encountered the same issue.

    Version of server : August 2018

    Version of PBI Desktop RS : August 2018

    We can open and save paginated reports on server, but can't open nor save PBI reports on server.
    On log, stricly nothing appears !!

    Only a "Unexpected error encountered" when trying to save report.

    I try of course all tips provided (change account, ...) but nothing works.

     

     

    regards

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support

    Hi shamsuddeenvp,

     

    Please check if you create this report in Power BI Desktop (Power BI Report Server). You can save the .pbix file local, then upload the file to report server via Upload option.

     

     

    Best Regards,
    Qiuyun Yu

    • shamsuddeenvp's avatar
      shamsuddeenvp
      Icon for Post Patron rankPost Patron

      Thanks v-qiuyu-msft

       

      I tried this as well, However the file is not getting deployed. Doesnt throw any error.

       

      Br,

      Shams

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Icon for Community Support rankCommunity Support

        shamsuddeenvpAFoXIANG Please share the complete log files around the time error throws out under this oath: C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles.

         

        Best Regards,
        Qiuyun Yu

    • XIANG's avatar
      XIANG
      Icon for Helper I rankHelper I

      Hello, v-qiuyu-msft  

       

      I have the same problem here. 

      I created the report via Power BI Report by powerbi desktop (report server)  

      i can save the file local, but when i want to save the report to power bi report server is says the same error 

       

      • AFo's avatar
        AFo
        Frequent Visitor

        I also have the same problem trying to upload PBI report to the PowerBI Report Server May Preview. Using the latest (May preview) PowerBI Desktop (Report Server), the report has a tabular data source but get the error "An error occured while attempting to save the report to Power BI Report Server." 

        Saving the pbix locally and trying to upload via the Power BI Report Server portal does not work either.

         

        Enabling tracing in PBI desktop didn't give any error, however I did find an error in the RSPortal_yyyy_mm_dd_hh_mm_ss.txt log in C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles.

         

        RSPortal!reportserverwebapp!f6c!05/22/2017-12:57:00:: e ERROR: OData exception occurred: System.Net.WebException: The remote server returned an error: (404) Not Found.
        at System.Net.HttpWebRequest.GetResponse()
        at Microsoft.ReportingServices.Portal.ODataWebApi.Utils.PbixReportHelper.ValidateRenderingIsSupportedAndSetProperties(PowerBIReport entity, Uri requestUri, ILogger logger)
        at Microsoft.ReportingServices.Portal.ODataWebApi.V2.Controllers.CatalogItemsController.ValidatePbiReportRenderingIsSupportedAndSetProperties(PowerBIReport item, Uri requestUri)
        at Microsoft.ReportingServices.Portal.ODataWebApi.V2.Controllers.CatalogItemsController.AddEntity(CatalogItem entity, CatalogItem& createdEntity)
        at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.Reflection.EntitySetReflectionODataController`1.Post(ODataPath oDataPath, T value)
        at lambda_method(Closure , Object , Object[] )
        at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)
        at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)
        --- End of stack trace from previous location where exception was thrown ---

         

         

         

         

    • shamsuddeenvp's avatar
      shamsuddeenvp
      Icon for Post Patron rankPost Patron

      Dear v-qiuyu-msft

       

      I tried to reinstall. Now I am facing other issue that report instance PBIRS is not appearing in the list. Please find below the screenshot. What would be the root cause of this issue?

       

      Br,

      Shams

       

  • Hello v-qiuyu-msft and all 

     

    Thanks for your help, now i could publish my PowerBI report to the PBI report server. 

    for conclusion:

    here is my situation 

    i used SSAS tabular mode as the datasource.

    i have SSRS report server and SSRS PBI report server on the same machine 

    and I have a instance "A" for SSRS RS and instance "B" (PBIRS) like default install for SSRS PBI   

    i configured  URL : http://server_name:80/Reports_A for SSRS report server  web portal 

          and         URL : http://serverè_name:81/Reports_PBI for SSRS PBI report server web protal. 

     

    then  i  tried to deploy the report to the PBI report server (i could deploy all the report(and create data source on the PBIRS except the PBI report.)   

    then after the suggestion of  v-qiuyu-msft   

    i changed the service account from Virtual service account to admin in the PBIRS manager. 

    Now i could depoy the PBI report to the PBIRS 

     

    Thanks =>

    Regards 

     

     

  • jayjay1's avatar
    jayjay1
    Frequent Visitor

    Hi Shams, 

     

    I was getting the same 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

  • I have the same issue with the August 2018 release.

     

    Power BI Desktop: 2.61.5192.641 64-bit (August 2018)

    Power BI Report Server: 1.3.6816.37243 (August 2018)

     

    The errors are:

    1) Save as: "An error occurred while attempting to save the report to Power BI Report Server"

    2) Upload any file from PBIRS: "There was an error uploading your .pbix file. Verify that the file has not been corrupted and that the file extension matches the format of the file."

     

    I can see an error in the logs: "Unable to connect to the remote server", which I guess may refer to the ReportServer database. However, I can create new folders from PBIRS. It does not seem to be a SSAS issue, as I get the same errors deploying or uploading a report with just text.

     

    Any ideas welcome, other than just using Azure.

    • goliash's avatar
      goliash
      Frequent Visitor

      Hello,

      I´m facing the same problem with the January 2019 release.

      Both versions, the Desktop and the PBI RS are the same version.

      Desktop:

      • Feedback Type: Frown (Error)
      • Timestamp: 2019-02-28T13:39:04.0099287Z
      • Local Time: 2019-02-28T14:39:04.0099287+01:00
      • Session ID: 0b347741-7890-48d0-802d-f9762511f96f
      • Release: January, 2019
      • Product Version: 2.65.5313.1562 (18.12) (x64)
      • OS Version: Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 en-US)
      • CLR Version: 4.6.1 or later [Release Number = 394271]
      • Peak Virtual Memory: 3.8 GB
      • Private Memory: 374 MB
      • Peak Working Set: 462 MB
      • IE Version: 11.0.9600.19266

      Report Server:

      • Product Version: 15.0.1102.235


      Unable to save PBIX from desktop to server and uplod PBIX to server as well.

      Any idea how to fix it?

      Thx

      Mario

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hello all!

         

        I have the same issue with a new installed Power BI ReportServer. We use a separate AD account and when I add this one to the lcoal "Administrators" group then I can upload PBIX files. When the serviceaccount isn't part of local "Administrators" then I'm unable to upload and get that error.

        So I tried and added this serviceaccount in the "User Rights Assignment" (Local Group Policy Editor) to the same policies as the "Administrators" are. But even then I cannot upload files.

        So I checked on the filesystem the most folders for Power BI ReportServer but the ServiceAccount has "Full Control" on these folders.

         

        Does anyone has a real solution for this? 😞

         

        Best regards

        Ronny