Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Satish_Kumar
Helper V
Helper V

How to configure the gateway for my Power BI service without Azure?

Hi All,

I have one Task to complete i.e. i want to connect my data source with my locally installed Gateway ,which i downloaded from Power BI gateway and do not have any AZURE database so can i connect with Gateway which is installed locally in my system,

if yes please guide me with steps involve.

 

 

Thanks In Advance!!!

 

 

 

Regards,

Satish Kumar

12 REPLIES 12
Seth_C_Bauer
Community Champion
Community Champion

@Satish_Kumar Which gateway did you install? The personal or the On Premises Data Gateway? The personal gateway will just work for supported datasources, the OPD gateway will require that you create a data source first in the PBI Service.

This example is for a SQL Server, but the steps would apply to other sources as well.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

@Seth_C_Bauer

I have installed the on premise Gateway avilable from Power BI.

@Satish_Kumar In the Power BI Service, have you created a data source for the gateway? Under Settings -> Manage Gateways -> Add Data Source?


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

@Seth_C_Bauer

Here is the main problem its is showing the gateway is offline and thatwhy i am not able to connect to the data source.

Hi @Satish_Kumar,

 

From the image, it seems that the data gateway isn't online. Please verify the gateway is running.

 

q1.PNG

 

Then start the on-premise data gateway, sign in with your account, make sure the status like below:

q2.PNG

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-qiuyu-msft

yes my On Premise gateway is running but i am able to see this message as you shown to me in pic.

Hi @Satish_Kumar,

 

Can you find the app on-premise data gateway in your computer, start it and sign in with your account?

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-qiuyu-msft

I tried but its always shows me that the gateway is offline.

Hi @Satish_Kumar,

 

How about updating the data gateway to the latest version? Make sure sign in account in data gateway is the same address as you used to login Power BI service.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@Satish_Kumar I assume you had no issue setting up the gateway on the server.

Did you change the Service account user?

Is your server part of the same domain registered with your tenant?

Have you accomodated all the firewall and proxy configurations?


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

@Seth_C_Bauer

No i have not change the server Account.

And all firewall activity is done with my machine.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors