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.

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

Make sure that the gateway service has access to the folder where the SQLite database file is stored.

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