On-premises data gateway and New Connection Help!

Kyle_AspirEDU — Thu, 17 Aug 2023 02:04:40 GMT

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

topic On-premises data gateway and New Connection Help! in Report Server

On-premises data gateway and New Connection Help!