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,
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.
