cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vitalicloud
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
henriquesilveir Resolver IV
Resolver IV

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

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?

henriquesilveir Resolver IV
Resolver IV

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

Re: Personal Gateway with DirectQuery?

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

 

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.

henriquesilveir Resolver IV
Resolver IV

Re: Personal Gateway with DirectQuery?

OK. after this it aren't work ? 

Highlighted
vitalicloud
Frequent Visitor

Re: Personal Gateway with DirectQuery?

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 Resolver IV
Resolver IV

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

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

 

If only it could work with DirectQuery!

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.