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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jaidee
Helper II
Helper II

Power BI Gateway Personal - can't run

I have som reports on app.powerbi.com.

 

I need some schedules refreshes so I download BI Gateway personal. But when I install it says connection established: you are running.

When I open the program nothing happes. I thought I had to enter some information in the gateway?

 

I Power BI Online under Settings and Datasets Gateway connection, legitimation and schedule update are all greyed out.

9 REPLIES 9
ankitpatira
Community Champion
Community Champion

@jaidee Have you checked following ?

 

Your gateway is running (ie machine it is installed in is not offline or turned off). Have you setup your gateway properly (ie you've supplied credentials to connect it to your on-prem data source). Above is the basic steps you take to run gateway. Please reply back with more details if you schedule refresh is still greyed out.

Hi

 

@ankitpatira

 

It is running when I look in the task bar. But I cannot open it setup credentials and so in. After installation it also dont ask me to do that.

@jaidee if after installation you're not getting any credentails asked you might already have one instanced installed. You should uninstall all instances then download latest one and re-install. Also follow guid on below link to troubleshoot.

 

https://powerbi.microsoft.com/en-us/documentation/powerbi-personal-gateway/#setting-up-a-gateway-for...

 

Let me know if you still have any specific questions.

I have un-installed and installed several times. After installation and/or when I open the app from task bar, it just says running.

 

But I have not entered something. Mayby it can have something to do with that I am using a machine where I am logged in on my companys AD?

@jaidee ensure in powerbi service you have data source credentials entered. it will give you error if you haven't.

 

Capture.PNG

I got the Personal Gateway to work on another PC than the one from my work. So now I can enter credentials in gateway, and see it on app.powerbi.com as online.

 

But it is not working, when I enter credentials (Basis not windows. In Desktop I use Database) )for my online MYSQL DB. It dont accept  and says I need to download MYSQL Connector Net 64 bit (It is only to be found in 32 bit).

 

After that I read, that when it is an online MYSQL (Not Azure) I mayby dont need the Gateway? And I should just update and schedule from the dataset online. I tried to upload a Power BI Desktop File in app.powerbi.com. But I still cannot connect to the db with my credential for auto refresh. 

 

kcantor
Community Champion
Community Champion

Make sure you are using the newest version of both the Gateway and PowerBI Desktop. For some reason if they are not both the same version it won't work for me. this may be the case for you as well.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




@ankitpatira I have the newest versions.

 

It seems so odd to me, that I can log in and refresh on Desktop, but when I use the same credentials on app.powerbi.com under Data source credentialt it says my credentials are invalid.

The server and DB names are pre-defined and greyed out and I use the correct username and password for the MySQL DB under Basic authentication method.

 

Is there a difference between the desktop and online? On desktop I can check wether to use a secure connection.

When I go to settings - administrate gateways the site says:

 

You have no company gateways. You have not created any company gateways yes.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors