Because the identify implies, SQLite is a light-weight weight transactional SQL database engine. It’s open-source and free to be used both for private business. SQLite is broadly utilized in cell apps and lots of different desktop purposes that want an inside mild weight free SQL database. On this publish I clarify find out how to visualise SQLite knowledge in Energy BI.
To have the ability to undergo the method that you must meet the next necessities:
- Newest Model of Energy BI Desktop (Present model: 2.52.4921.682 64-bit (November/2017))
- Set up SQLite ODBC driver: Ensure you set up 64 bit model in case your Energy BI Desktop is 64 bit model like mine!
Notice: It’s possible you’ll set up each x32 and x64 bit variations of the motive force in case your different purposes are in x32 bit.
- An current SQLite database
Notice: In case you simply wish to do that and also you don’t presently have a SQLite database you possibly can obtain a SQLite model of “Web Gross sales” of AdventrueWorksDW2016 that I made obtainable for you.
Like every other Energy BI instances, it’s very easy to load knowledge from an current SQLite database to a Energy BI Desktop mannequin. You simply want to make use of ODBC knowledge connection and hook up with a predefined “ODBC DNS” OR use a “Connection String”. I’ll clarify each strategies. After you load knowledge to your Energy BI Desktop, you create the relationships then you definitely’re good to go and create flashy reviews. Proceed studying for those who’re to an step-by-step information to visualise SQLite knowledge In Energy BI.
Importing SQLite Knowledge to Energy BI Utilizing ODBC DSN
- Open the right model (x32, x64) of ODBC after you downloaded and put in SQLite ODBC Driver
- Click on “Drivers” tab and ensure SQLite ODBC Driver(s) efficiently put in
Click on “Person DSN” tab then click on “Add”
- Choose applicable driver from the checklist, in my case it’s “SQLite3 ODBC Driver”
- Click on “End”
- Enter a reputation for the info supply
- Click on “Browse” and find your SQLite database then click on OK
Now you efficiently created an ODBC DSN that can be utilized in Energy BI to hook up with SQLite.
- Open Energy BI Desktop
- Choose “ODBC” from “Get Knowledge” then click on “Join”
- Choose the DSN you created earlier from the dropdown checklist then click on OK
Click on “Default or Customized” tab then click on “Join”
Choose the specified tables from the checklist then click on both load
After you imported knowledge into Energy BI that you must manually create the relationships between the tables
Now you’re good to go and create reviews.
Importing SQLite Knowledge to Energy BI Utilizing Connection String
- After you put in SQLite ODBC drivers, open Energy BI Desktop
- Choose “ODBC” from “Get Knowledge”
- Choose “SQLite3 Datasource” from the dropdown checklist
- Click on “Superior choices”
- Now kind “database=” adopted by your SQLite file path then click on OK
Click on “Default or Customized” tab then click on OK
The remaining is similar as earlier methodology.
All carried out! 
