Powershell Script to read and update .ps1 payload from SQLite

I have an SQLite database with (3) tables. I need to update Power BI from these tables in near real-time using a push method and want to use Powershells' $Connection, $Payload and Invoke-Rest cmdlets to accomplish this. You would do the following: 1. Create the Powershell code to read values from the (3) SQLite tables and store those values into the PowershellScript as a $payload, 2. Adivse or create the process/service for the .PS1 file to run every 30 seconds. The SQLite tables are small, aveage 10 columns per table.