Forum Discussion

OLoughanD's avatar
OLoughanD
Icon for Helper I rankHelper I
8 years ago
Solved

On-Premise Gateway Issues

Hi,   Have decided to deploy Power BI and On-Premise Gateway. Have researched them both.   Downloaded the gateway and installed. Created a free account online. The gateway and data source are con...
Need Help
  • OLoughanD's avatar
    OLoughanD
    8 years ago

    Looks like we got this sorted. We'd followed some instructional videos on YouTube but they don't make the process clear.

     

    We had created the Gateway and Data Source. What was not apparent is that this would not create the dataset. We expected from what had been demonstrated in the videos that it would.

     

    Instead the report creator needs to open Power BI Desktop and connect (on-site or remotely using VPN) to the SQL server. They then create the report. When done they publish it to the Power BI service online. When this is done the report is available via the Power BI service online. The dataset is also created. It is important to alter the dataset at this point to select the gateway that is used to refresh it. Once we had done this we not only had the dataset but we were able to refresh the data.

     

    Thanks all for your input.

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
8 years ago
You could always try and force it over HTTPS to see if that initially resolves your error.

If that does then you know it has to do with additional ports that will be required to be opened.
  • OLoughanD's avatar
    OLoughanD
    Icon for Helper I rankHelper I
    8 years ago

    Hi GilbertQ,

     

    Thanks for your message. We had tried this too, but still no luck.

     

    Regards!

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      8 years ago
      Hi there

      If HTTPS does not work then it is possible that the server is locked down to specific websites.
      • OLoughanD's avatar
        OLoughanD
        Icon for Helper I rankHelper I
        8 years ago

        Hi GilbertQ

         

        The server configuration is very basic. There is no high-level security implemented that would restrict the server in this way. It is a real mystery.

         

        Regards