Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

SQLite connection refresh not working

I have an SQLite DB on my localhost installed. There is no authentication on it without any privacy level. I have the correct x64 ODBC SQlite3 driver installed under System DSN: Data Source Name: L...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Unlike other databases SQLite is entirely stored in a single file on disk.  You need to make sure that the user account running the gateway (by default PBIEGWService) has read access to that file. Otherwise your ODBC connection won't be able to read the data.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,

I don't understand what you mean... Can you please describe in more details?


I don't find anything in the On-premises data gateway app when it's open and ready.
I setup everything under the Data gateway connections and it shows it's online.

I don't know what else I could configure...

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Unlike other databases SQLite is entirely stored in a single file on disk.  You need to make sure that the user account running the gateway (by default PBIEGWService) has read access to that file. Otherwise your ODBC connection won't be able to read the data.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Many many thanks. 😍

    I had to add NT SERVICE\PBIEgwService account to the folder's Security settings and it solved the refresh issue.