![]() ![]() Note: You may install both x32 and 圆4 bit versions of the driver if your other applications are in x32 bit. Install SQLite ODBC driver: Make sure you install 64 bit version if your Power BI Desktop is 64 bit version like mine!.Latest Version of Power BI Desktop (Current version.To be able to go through the process you need to meet the following requirements: In this post I explain how to visualise SQLite data in Power BI. SQLite is widely used in mobile apps and many other desktop applications that need an internal light weight free SQL database. It is open-source and free for use either for personal commercial. ![]() If this does not work speak to your DBA (database administrator) about the user credentials you should use to connect to the database.As the name implies, SQLite is a light weight transactional SQL database engine. Using integrated security is the usual way to connect to a Microsoft SQL Server database. Speak to your database administrator (DBA) or network administrator. SQL Server defaults to port 1433, but a different port can be used. Please contact us at if you need to know the latest supported version of the ODBC drivers. Iguana may not always support the very latest version of the ODBC drivers:.Speak to your DBA (database administrator) for general connection issues like: User name and password, Database Server network name etc. Finally test the connection to see that the changes worked.Choose your default database from the drop list and click Next:.Select the Change the default database option:.Choose SQL Server Authentication, enter User and Password and click Next:.Choose the ODBC source and click Configure and click Next:.Modify the ODBC source to change Database and User:.User Login: Change to user billsmith with password something-secret.These are the two most common things to change:. ![]() If you need to modify the ODBC source follow these steps:
0 Comments
Leave a Reply. |