Power BI Gateway Enterprise connects and DSN shows, but credentials just hang

[unclejemima]

I have a enterprise gateway installed, everything tests ok.  When I go into the Power BI online and click on "schedule refresh", then it shows Gateway connection where "use your data gateway- personal" is selected and greyed out, and use data gateway is also greyed out and can't be selected.

Data Source Connections shows "Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.".  Both connections show ( I have one ODBC connection to a Pervasive DB and one Excel spreadsheet) but when I click on "edit credentials" it just loads and loads and loads with no error showing.

Can someone give me advice as to why I can't select the "data gateway" enterprise and why the credentials just load and load and load without error.

Thanks!

[unclejemima]

Anyone?

Here is a screenshot.

[unclejemima · Accepted solution]

I might have just answered my own question.  As I'm trying to connect to an excel file and one ODBC connection to a Pervasive DB, then the enterprise will never work...

Here is what I found...

The Personal Gateway takes the data and imports it into Power BI. If you want to extract data from a variety of different places such as an Oracle Database, and Excel Spreadsheets, the Personal Gateway will support this, and the Enterprise Gateway won’t.   Remember the Enterprise Gateway only connects to three different data sources, and Excel and Oracle are not on that list. If you want to manage connection and refresh of the data as the administrator or provide access to the data to everyone who needs it, use the Personal Gateway.

So back to personal and hoping it actually works from here out.  Mine would always disconnect when the server rebooted.  Hope this helps others to avoid the enterprise gateway as its not meant to do the same thing.