Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Personal Gateway with DirectQuery?

Hi,

I've been trying to make the Personal Gateway to show up in the dataset settings for a while and couldn't figure it out why it did show up in some reports but didn't in others!

Now I have figured it out! Apparently, if I switch from DirectQuery to Import mode the Personal Gateway does show up in the list and I can use it.

 

So, how can I make the Personal Gateway also show up in my DirectQuery reports/datasets and not just the Import ones?

 

Thanks.

Need Help

10 Replies

  • henriquesilveir's avatar
    henriquesilveir
    Resolver IV
    7 years ago

    Anonymous Hello, have you configured yours credentials into powerbi.app ? 

     

     

    Below an article about gateway personal: https://docs.microsoft.com/pt-br/power-bi/service-gateway-personal-mode

     

    The personal works like a application... because this, when you import, you set all credentials and it works fine. Now, to work into direct query, you need configure yours credentials into Power BI Service.

     

    Let me know if you solve this problem, waiting on you! 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I believe I'm logged in in both the Power BI app and the Personal Gateway app?

      Unless there's some hidden place where I need to enter my credentials?

       

      1. In Power BI Desktop, when I open the menu it shows "Sign Out" button and on the top right of the app it shows my name - I guess I'm logged in.

      2. In Power BI Desktop, when I open the menu and select "Options and settings" and then "Data source settings", there is one database in the list, if I click on it and select "Edit Permissions..." it says I'm logged in with my Windows credentials. Another tick!

      3. In the Personal Gateway app, right after I installed it, it asked me to sign in. If I open the app now it doesn't show my name or an option to sign out or sign in. But I definitely put my credentials right after installing it!

       

      So far I can think of the above 3 places! Not sure if there's another place I need to check?

      • henriquesilveir's avatar
        henriquesilveir
        Resolver IV
        7 years ago

        Anonymous you need to enter your credetials at dataset in the Power BI APP (Cloud), take a look below:

         

         

        you need set up here: (https://docs.microsoft.com/en-us/power-bi/service-gateway-personal-mode)

         

        Choose your personal data gateway, it the place off 'install' , below have 'data source credentials' when you set this 2 steps , it will work. 

         

        I've attached the article that have the complete solution for personal gateway.