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 IHi Yuliana,
I'll do that. Thank you.
David
Helper ILooks 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.
Iam having the similar network port failed issue
g34-prod-by3-007-sb.servicebus.windows.net 40.78.58.134 FAILED
g40-prod-by3-007-sb.servicebus.windows.net 23.99.83.111 FAILED
g43-prod-by3-007-sb.servicebus.windows.net 138.91.250.253 FAILEDMay I know what is the solution.
- GilbertQ
Super User
Hi there,
Could try and change the setting to use HTTPS and see if that works?
If that does work it would indicate to me that your firewall is blocking the access. Thanks for the reply.
I have already tried this HTTPS mode and also had double checked with my Infra team and there is no blockage from our network firewall. Iam surprised to see this happening even in my personal laptop, which does not connect to any network except internet.
- GilbertQHi there
Possibly anti virus or something similar that is stopping the ports from being accessed? - OLoughanD
Hi,
I don't think we ever solved the issue. Turned out to be a bit of red herring.
We had been working on the basis of a video we had watched. During the course of trying to diagnose why we couldn't get the service working we encountered the network ports issue. We figured this had something to do with the problem. I don't believe it did have any bearing. In fact we managed to get the diagnostic to success and fail, depending on when we ran it and without any network configuation changes.
We had expected to see some DataSet item in the PowerBI online console and we had expected that we would have to connect our reports to it. The service doesn't work that way.
What we did:
1. Create the PowerBI account online
2. Install the PowerBI gateway (we put it on a server where we also installed Power BI desktop)
3. Create a report.
4. Save it and click Publish.
5. The report now appears on the online PowerBI account where it can be shared.
Hope this helps. Don't put much faith in the network ports being the source of your problems.
- GilbertQAwesome, thanks for letting us know
