- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
On-premises data gateway and New Connection Help!
Good evening,
First, let me apologize for the ignorance of my question, but I am at a loss now. Also, I apologize for the length of the post; I want to provide as much helpful information to the community as possible. I am hoping for your assistance.
The situation...I have a database file that I have connected to my Power BI desktop app through the use of the ODBC driver. The dataset connects perfectly with no issues, and I use "Windows Credentials" to finish the connection.
As you might have guessed, I want to auto-refresh this data to my Power BI app. In order to do this, I have installed and am running the On-Premises data gateway(Not personal). The gateway is up and running, and when I visit my workspace, where I have published the report/dataset I can clearly see the correct data gateway running, but the dataset (the SQLite file) is not correctly configured.
I then click on the "add to gateway" button, next to the dataset, to create a new connection between this dataset and the on-premises gateway. I added a connection name, the connect type is correct, "ODBC", the connection string looks correct, and then I selected Authentication Method windows.
Here is where I run into issues. For the life of me, I cannot figure out what credentials to use, and I have tried everything. When I first establish the connection in my Power BI desktop, I choose "Use Window Credentials" to connect to the ODBC dataset. Whatever I try, I keep seeing the error invalid credentials.
I am figuring I am missing something, or I have not set up some sort of username/password for the dataset, but I would love the help of this community. What am I missing or what credentials should I be using?
Thank you

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 03-03-2021 09:00 AM | ||
12-24-2020 09:37 AM | |||
04-23-2024 02:54 AM | |||
05-24-2024 09:55 AM | |||
08-17-2023 11:35 AM |