Personal Gateway with DirectQuery?

[Anonymous]

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.

[Joseph_B]

Hi,

I belive you haven't solve this issue yet.

Maybe a hint might be in documentation of using personal gateway.

https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode

When you are selecting that you want to install On-premises data gateway in personal mode, one of the points below is that only schedule refresh is supported.

Scheduled refresh is working with import mode, not with direct query or live connections.

Thanks

[henriquesilveir]

@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]

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]

@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.

[Anonymous]

Ah, I see! That's what I meant, that it doesn't show up. 🙂

This is the dataset for my report that uses Import:

As you can see the Personal Gateway is shining bright like a diamond!

And here is the dataset for the report that uses DirectQuery:

In here the children only heard stories of the Personal Gateway' existence but have never seen it with their own eyes.

[henriquesilveir]

OK. after this it aren't work ? 

[Anonymous]

I don't see an "Install Now" option or anything to choose the Personal Gateway. 😐

It works with the reports that use Import, but the Personal Gateway doesn't appear for reports using DirectQuery.

[henriquesilveir]

understood... question.. the server with direct query, have you acess there ? 

option, install a data gateway on server or personal.. it will be available for you, i absoluty sure about that! 

[Anonymous]

I mean I have credentials to access the SQL Server to run queries, but I don't have access to the actual server to install/uninstall things.

Personal Gateway is very useful as I can access files from my PC AND also access the SQL Server. 🙂

If only it could work with DirectQuery!

[gracez]

I have the same problem. Gateway personal worked for import dataset, but not directquery dataset. Have you solved this gateway issue? Thanks.