How to get local folder/Shareppoint *.sqlite file?

[Andrew_Lu81]

I use sqlite to store data, I want regular to refresh and place sqlite in sharepoint, how to read the sqlite into pq/pbi?

I have reply chatgpt, it said use SQlite.Database to read *.sqlite file?

[Adamboer]

To get the local folder/SharePoint *.sqlite file and read it into Power Query (PQ) or Power BI (PBI), you can follow these steps:

1. Save your *.sqlite file in a local folder or SharePoint site. Make sure you have the necessary permissions to access the folder or site.

2. Open Power Query or Power BI, and go to the Home tab. Click on the "Get Data" button and select "Blank Query" from the dropdown menu.

3. In the Query Editor window, go to the Home tab again and click on the "Advanced Editor" button. This will open the Advanced Editor window, where you can write custom M code to read your *.sqlite file.

4. In the Advanced Editor window, use the following code to read the *.sqlite file:

let Source = Sqlite.Database("path_to_sqlite_file\file_name.sqlite") in Source

Replace "path_to_sqlite_file" with the path to your local folder or SharePoint site, and replace "file_name.sqlite" with the name of your *.sqlite file.

1. Click on the "Done" button to close the Advanced Editor window. You will see a preview of your data in the Query Editor window.

2. If you want to refresh the data regularly, you can go to the Home tab and click on the "Refresh All" button. This will update the data in your PQ or PBI report based on the latest data in your *.sqlite file.

By following these steps, you should be able to read your *.sqlite file into PQ or PBI and refresh the data regularly.