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.
Microsoft EmployeeHi OLoughanD,
It looks like the connection is blocked by firewall. You can confirm this problem by by running Test-NetConnection from a PowerShell prompt. If that is the case, you may need to whitelist (unblock) the IP addresses, for your data region, in your firewall.
Best regards,
Yuliana Gu
Helper IHi Yuliana,
Thanks for your message. We don't think it is anything to do with firewalling. We disabled various functionality to check and the result stayed the same. We also re-ran the Network Ports test and we have had it work perfectly during some tests. Yet at other times it does not work. It is always the same last two servers that fail. This kind of behaviour does not indicate the firewall is the issue.
Regards!