cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
unclejemima
Post Patron
Post Patron

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

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!

 

 

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

View solution in original post

2 REPLIES 2
unclejemima
Post Patron
Post Patron

Anyone?

 

Here is a screenshot.

 

screenshot power bi.JPG

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.

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors