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
unclejemima
Post Patron
Post Patron

Data Source Settings for Gateway

I setup an enterprise gateway and can successfuly connect to it, and can upload my files from Power BI desktop (on prem) to the online service.  From what I understand the Enterprise version can run as a service, unlike the personal what runs as an application...this make the enterprise gateway much better?

 

I can not get the scheduled refresh working as I understand that I have to manually setup the data sources in the gateway, instead of it just knowing what ones are in the report and it being able to do its own refresh from the credentials of the uploaded report that is on the server.

 

With that, I'm tryin got add a new data source under the gateway cluster, and I have a Pervasive Database and 1 excel file (located on the same server) connected in the power BI desktop report that I'm trying to use.  Is there a way to copy and paste the connection string from the power bi desktop report as i'm not sure what it is.  Also, I'm fairly certain there is no username or password for the database...but when adding a data source to the gateway cluster and selecting ODBC datasource, it won't accept null values for the username and password.

 

help! 🙂

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi there

Have a look at this post and see if it helps you below. What I would suggest is to just put anything into the username and password even though it is not required, but it will satisfy the gateway data source.

https://community.powerbi.com/t5/Service/Enterprise-Gateway-with-ODBC/td-p/98959

And here is another link which might assist you:
https://docs.microsoft.com/en-us/power-bi/desktop-connect-using-generic-interfaces




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

Proud to be a Super User!







Power BI Blog

View solution in original post

1 REPLY 1
GilbertQ
Super User
Super User

Hi there

Have a look at this post and see if it helps you below. What I would suggest is to just put anything into the username and password even though it is not required, but it will satisfy the gateway data source.

https://community.powerbi.com/t5/Service/Enterprise-Gateway-with-ODBC/td-p/98959

And here is another link which might assist you:
https://docs.microsoft.com/en-us/power-bi/desktop-connect-using-generic-interfaces




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

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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