Can you connect to a SQLite database using Power BI ?

Yes, you can.

Power BI is the Microsoft product for business intelligence. SQLite is well known for its use in mobile platforms and embedded apps.

There is no native way of connecting to SQLite using Power BI, but you could use the ODBC driver which was described in an earlier post.

Read here:
ODBC Drivers for SQLite:

Read here:
Creating ODBC DSN for SQLite3:
https://hodentekmsss.blogspot.com/2018/04/creating-odbc-dsn-for-connecting-to.html

Connecting to SQLite3 using Power BI is easy. Here are the steps.

Launch Power BI and open the Get Data menu as shown.

In the list in the Other clic on ODBC.

Highlight the DSN, ODBCSQLite and Click OK. 

Change it to Windows (this may not be necessary) and click Connect.

The From ODBC window is displayed. Click on Advanced Options to display the pane where you can write a SQL Statement.

It goes through from processing and since there is no table by that name, it returns an error.

Now change the SQL Statement to the following:

Select * from Users

After some processing it get connected.

Now you can find the table details in Navigator as shown.

Power BI does not show the tables and write a query you need to know the objects you created in SQLite database.

How do you use MS Query in MS Excel 2010?

MS Query is used to import data into a MS Excel application (Work sheet) in Microsoft Excel. Here Microsoft Excel in the Microsoft Office Professional Plus 2013 (x32bit)  suite is used.

Using Microsoft Query data from a table in SQL Server 2012 can be imported into an excel sheet. The process is explained in great detail here:

http://hodentekmsss.blogspot.com/2014/07/how-do-you-import-data-from-sql-server.html

In order to carry out the steps in the above, you must first create an ODBC connection to SQL Server (in this case SQL Server 2012 Express) will be required. If you do not have a DSN made follow this link to learn how:

http://hodentekmsss.blogspot.com/2013/08/how-do-you-create-odbc-dsn-to-sql.html