Forum Discussion

amoine's avatar
amoine
Frequent Visitor
11 years ago

How to remove personal gateway from app.powerbi.com

I,   I successfully uninstalled personal gateway from my server. But it is still visible on app.powerbi.com, with an error saying that gateway is unavailable. I can't refresh my datasources becau...
Need Help
ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
10 years ago

Ditto that. I too have a Personal Gateway installed on a VM that NO LONGER RUNS, but for some reason, when I deploy a DataSet to Power BI via a PBIX file, then try to set up Scheduled Refresh on it, it seems to be stuck to the Personal Gateway, even though this particular PBIX was created on a machine and connected to data on a machine that has a functioning Enterprise Gateway installed.

  • Evogelpohl's avatar
    Evogelpohl
    Icon for Helper V rankHelper V
    10 years ago

    ToddChitt Anonymous.  

     

    Update:  I've been working with a Support rep @ MS for this issue.  Still occurs.  He ran me through the same bullets items I did in an earlier post.  Same outcome - the Service still thinks my PG is registered, but offline & won't let me convert the data set over to the EG.  

     

    He told me that "it takes special permission from Microsoft for him to be able to view issues w/ my PG" - he's working to get that approval. Told me to stand by.

     

    -Eric.

    • ToddChitt's avatar
      ToddChitt
      Icon for Super User rankSuper User
      10 years ago

      This solved it for me:

      Open the PBIX file. Get into Edit Queries. For each table, get into the Advanced Editor. Check the Server and Database name in the second line (   Source = Sql.database("server","database")   ). Once I made sure that the server name and database name referenced here match a server name and database name of a Data Source in the Enterprise Gateway, then I was able to connect the Dataset and configure refreshes.

       

      In my opinion, at least for me, the orphaned Personal Gateway was only the fall back default because Power BI could not find a matching pair of server/database for the Dataset. Once that was rectified, the issue was resolved.

       

      Hope this helps.

      • Evogelpohl's avatar
        Evogelpohl
        Icon for Helper V rankHelper V
        10 years ago

        ToddChitt.  Thanks Todd.  Did the same exact steps, line for line - ensuring my query & EG have the exact same name/case/FQDN.

         

        Alas, the Support Rep for PowerBI.Com asked that I provide an exhaustive list of Fiddler extracts, screen shots & all the steps I'm doing.  They won't screen-share w/ me as my Support Req was under the free service.  I don't have time to do all this homework.  I'm going to start from scratch & abandon the solutions that used my PG.

         

        -Eric.