Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, I've installed a new gateway in a server which I can't acccess from my computer. Is possible for me to create a report using the information in this server from my pc using the gateway?
Thank you
Solved! Go to Solution.
Hi,
Yes I have the on premise gateway installed and configured.
The problem was I didnt really know how to acces the information from bi desktop. I have other gateways installed in a local server that allow me to access information directly.
I finally came across two solutions. If anyone with the same problems here you go:
- Dataflow in web service. You create the dataflow in web and access it from power bi desktop
- Server alias. Assign your local server a nickname so it has the same nickname as the server name you are insterested on. Attack it from power bi desktop and once you have uploaded the report, refresh it on web service.
Hi @AntonioHR ,
On-premises data gateways act as bridges between on-premises data sources and cloud services, it provides quick and secure data transfer between on-premises data, which is data that isn't in the cloud, and several Microsoft clouds services.
Your workaround is to use Power BI Desktop to connect to the dataflow or dataset in the service, which contains the information of the data source, you can also use the credentials to connect to the data source through the gateway to get the latest data. This allows you to get data indirectly from the data source.
You can mark your own method as an answer to help more people find it quickly
Please refer to these documents, hope it helps.
On-premises data gateway architecture | Microsoft Docs
Best Regards,
Community Support Team_Gao
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi,
Yes I have the on premise gateway installed and configured.
The problem was I didnt really know how to acces the information from bi desktop. I have other gateways installed in a local server that allow me to access information directly.
I finally came across two solutions. If anyone with the same problems here you go:
- Dataflow in web service. You create the dataflow in web and access it from power bi desktop
- Server alias. Assign your local server a nickname so it has the same nickname as the server name you are insterested on. Attack it from power bi desktop and once you have uploaded the report, refresh it on web service.
Hi @AntonioHR
Have you just installed the on-premises gateway or configured it too?
Please have a look at below link to see hwo to configure gateway to start using it:
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install