# 使用 Power BI 連線 SQLITE

## 注意事項 Notice
1. Make sure install Power BI Desktop
2. 確認電腦是否有安裝 SQLite ODBC driver: Make sure you install 64 bit version if your power BI Desktop is 64bit

## Import SQLite Data to Power BI Using Connection String

1. After you installed SQLite ODBC drivers, open Power BI Desktop
2. Select “ODBC” from “Get Data”

3. Select “SQLite3 Datasource” from the dropdown list
4. Click “Advanced options”
5. Now type “database=” followed by your SQLite file path then click "確認"

### Notice:
1. If you want to filter the data from the raw data, you can type SQL statement in the column called "SQL Statement"
2.Reference: https://www.biinsight.com/visualise-sqlite-data-in-power-bi/

###### tags: `Power BI` `SQLITE`