Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 sh...
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.