cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vitalicloud Frequent Visitor
Frequent Visitor

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.

8 REPLIES 8

Re: Personal Gateway with DirectQuery?

@vitalicloud 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! 

vitalicloud Frequent Visitor
Frequent Visitor

Re: Personal Gateway with DirectQuery?

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?

Re: Personal Gateway with DirectQuery?

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

 

 

 

 

vitalicloud Frequent Visitor
Frequent Visitor

Re: Personal Gateway with DirectQuery?

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

 

This is the dataset for my report that uses Import:

dataset_with_import.png

 

 

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

 

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

dataset_with_directquery.png

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

Re: Personal Gateway with DirectQuery?

OK. after this it aren't work ? 

vitalicloud Frequent Visitor
Frequent Visitor

Re: Personal Gateway with DirectQuery?

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

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

Re: Personal Gateway with DirectQuery?

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! 

vitalicloud Frequent Visitor
Frequent Visitor

Re: Personal Gateway with DirectQuery?

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. Smiley Happy

 

If only it could work with DirectQuery!

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 331 members 3,421 guests
Please welcome our newest community members: