Visualise SQLite Knowledge in Energy BI

Because the title implies, SQLite is a lightweight weight transactional SQL database engine. It’s open-source and free to be used both for private business. SQLite is extensively utilized in cell apps and plenty of different desktop purposes that want an inner gentle weight free SQL database. On this publish I clarify how you can visualise SQLite information in Energy BI.

To have the ability to undergo the method it’s good to 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: Be sure you set up 64 bit model in case your Energy BI Desktop is 64 bit model like mine!

Be aware: It’s possible you’ll set up each x32 and x64 bit variations of the driving force in case your different purposes are in x32 bit.

• An present SQLite database

Be aware: In case you simply need to do this and also you don’t at the moment have a SQLite database you’ll be able to obtain a SQLite model of “Web Gross sales” of AdventrueWorksDW2016 that I made obtainable for you.

Like another Energy BI instances, it’s very easy to load information from an present SQLite database to a Energy BI Desktop mannequin. You simply want to make use of ODBC information connection and hook up with a predefined “ODBC DNS” OR use a “Connection String”. I’ll clarify each strategies. After you load information to your Energy BI Desktop, you create the relationships then you definitely’re good to go and create flashy experiences. Proceed studying in the event you’re to an step-by-step information to visualise SQLite information In Energy BI.

Importing SQLite Knowledge to Energy BI Utilizing ODBC DSN

• Open the proper 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 record, 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 connect with SQLite.

• Open Energy BI Desktop
• Choose “ODBC” from “Get Knowledge” then click on “Join”
• Choose the DSN you created earlier from the dropdown record then click on OK

Click on “Default or Customized” tab then click on “Join”

Choose the specified tables from the record then click on both load

After you imported information into Energy BI it’s good to manually create the relationships between the tables

Now you’re good to go and create experiences.

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 record
• Click on “Superior choices”
• Now sort “database=” adopted by your SQLite file path then click on OK

Click on “Default or Customized” tab then click on OK

The remainder is identical as earlier technique.

All completed!