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.
Helper ISome of the issues I have been experiencing appear not to be local. I did some additional testing lastnight and the Network Ports Test succeeded whereas it had failed persistently before. I tested this again this morning and the same test now fails again.
If I check the listed server port from an off-site source, I find the port on the Microsoft server is listed as closed: