Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Error when saving report to Power BI Report Server

So I reviewed the documentation, identified the correct ports, etc.    When I attempt to save a PBIX file from the Desktop for RS (launched either directly from my desktop or from the Power BI Serv...
Power BI Report Server
xantari's avatar
xantari
Helper II
8 years ago

Nothing published currently. Will try publish some of my SSRS reports shortly.

 

I can access the GUI (http://powerbi/reports) just fine via Chrome and IE.

cmikos's avatar
cmikos
Helper I
8 years ago

I'd stay away from your SSRS reports for now and just try to get something trivial published to Power BI Report Server with Power BI client getting data from an SSAS cube

  • xantari's avatar
    xantari
    Helper II
    8 years ago

    I don't have any SSAS cubes. The PowerBI Report I am attempting to publish is hooked to an IBM DB2 database. It runs fine locally.

    • xantari's avatar
      xantari
      Helper II
      8 years ago

      I figured out what it was.

       

      What lead me to the clue is the following:

       

      1. Browsing remotely to http://powerbi/reports and powerbi/reportserver worked just fine.

      2. Logged into the server and tried those same URLs and got HTTP 503 server unavailable errors, which I thought was wierd.

       

      So I did the following:

       

      1. Disabled Loopback check in windows (method 2 from this article: https://support.microsoft.com/en-us/help/896861/you-receive-error-401-1-when-you-browse-a-web-site-that-uses-integrate)

       

      2. Still didn't work

       

      3. Then went to IIS and noticed default website was there listening on port 80. I said what the heck and deleted it, and all the unused App Pools in IIS as I didn't have anything running under the default web site in IIS.

       

      That fixed it.

       

      I'm guessing that even though I was using host headers in Power BI for the /ReportServer and /Reports URLs it must have still been having a conflict with the default website running on port 80 for some reason. Host headers are supposed to prevent this, but I'm guessing there might be an issue in Power BI in regards to host headers and when it binds or something.

      • cmikos's avatar
        cmikos
        Helper I
        8 years ago

        Great troubleshooting, for anyone out there having similar issues try running this to check your reserved URLS:

         

        > netsh http show urlacl