Forum Discussion
Helper IOn-Premise Gateway Issues
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.
Super UserIf HTTPS does not work then it is possible that the server is locked down to specific websites.
Helper IHi 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
- GilbertQHi there,
I think that possibly the server is fine but there is a firewall preventing it from working.
You could test it by installing it on your own PC and see if that works?
If that does then ask your IT Admin to have a look at it for you?