Forum Discussion
Personal gateway can't identified
I need a gateway to publish a Power BI file which linked to local SQL server. So I installed On-Premises(Personal Mode).
But when I accessed Power BI website and tried configure "Gateway", there showed nothing.
It looks like I don't have any gateway.
How can I configure personal gateway?
Finally, I found the route cause!!
It was because "DirectQuery"!!
Personal gateway doesn't support "DirectQuery" mode. So I can't find gateway in datasets.
I created a brand new PBIX file using "import data" instead of "DirectQuery". Now I can use personal gateway.
Anyway, thanks a lot for all your help.
5 Replies
- lbendlin
Super User
Next step is to make sure the gateway service is actually running on your PC, and then to add the connection to the gateway (in the Manage gateways section for enterprise gateways, not sure how that works for personal gateways)
Make sure to use EXACTLY the same connection details on the gateway and in your PBIX file.
If the gateway is still not visible you may have other on-prem datasources in your PBIX file that you need to declare in the gateway.
Thanks for your reply. But I still can't see any gateway in "Manage Gateways".
I didn't add any on-prem datasources in my PBIX file. I just inptut the sever name and datasource name in PBIX.
Also I really don't understand how to check if the personal gateway actully running on my laptop, cause I can't find its icon in the taskbar.
- lbendlin
Look in Services. It should be listed there as running.
Finally, I found the route cause!!
It was because "DirectQuery"!!
Personal gateway doesn't support "DirectQuery" mode. So I can't find gateway in datasets.
I created a brand new PBIX file using "import data" instead of "DirectQuery". Now I can use personal gateway.
Anyway, thanks a lot for all your help.
