Learn about Microsoft Power BI Series-TIPS (6) Connect with SQLite database

Source: Internet
Author: User
Tags odbc rar sqlite sqlite database power bi

Long time no research power BI, see goofy big God to get things, too ashamed. Today there is a small thing, data in SQLite, want to Daoteng to power BI desktop inside toss, the results found not directly support. So had to bite the bullet to go, or else Daoteng to Excel also bother. I see support for ODBC drivers and think there's a way. Take a look at how power BI desktop connects to the SQLite database.

Power BI Article catalog: Microsoft Power BI Technical articles and resources catalog

This text address: http://www.cnblogs.com/asxinyu/p/Power_BI_Skills_Sqlite.html

1.ODBC Drive

First use search engine to find the article, found a few English:



Seems to be the driving problem, but everything is difficult at the beginning, a few articles mentioned in the links are not open ... And the SQLite website has no ODBC driver,

GitHub found the open source, but also the above address ... No way, another search, here omitted 1000 words, found the 32-bit and 64-bit SQLite ODBC driver.

The article is provided later, so as not to repeat the same, very painful.

The installation process is simple, remember to remember: To install your power BI desktop corresponding to the 32-bit or 64-bit version.

If you don't know what your power BI desktop version is, open: File->help->about, such as:

2.Power BI Desktop Connection SQLite

Later I also prepared a SQLite provincial information file, you can see. Here's a look at the connection method:

GetData, then select Other, and then select ODBC, such as:

Then click Connect Connection, see the following interface, if you do not install the above driver, the red box East is not.

Note that the above is SQLite3 DataSource, if it is Sqlite2 version, the driver installation process can be checked Sqlite2, hook on the good.

After selecting, open Advanced options, enter the connection string and the SQL statement you want to query (you can also add later):

Connection string: Driver={sqlite3 ODBC driver};d atabase=d:\china_regions.db;longnames=0;timeout=1000;notxn=0

Note that the file path itself, the other parameters can be self-search, I just copied one over, SQL is also the simplest:

SELECT * from Province

After the confirmation, the data will come out, the rest of you understand ....

3. Resources

1.sqlite3 ODBC driver Download: Sqliteodbc.rar

2.Sqlite sample file Download: China_regions.rar

Learn about Microsoft Power BI Series-TIPS (6) Connect with SQLite database

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.