Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Andrew_Lu81
New Member

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

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?

1 REPLY 1
Adamboer
Responsive Resident
Responsive Resident

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.

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors