Skip to main content

    Power BI

    New

    Provide full support for SQLite database file as OneDrive data source

    Vote (60) Share
    Paul Chehowski's profile image

    Paul Chehowski on 10 Jul 2015 03:03:12

    Please provide support for use of a SQLite database file in OneDrive folder as a PowerBI data source supporting Refresh capability.

    Comments (9)
    Paul Chehowski's profile image Profile Picture

    e2bb0f25 bdba-4a07-b365-ae3f814f22b9 on 05 Jul 2020 23:27:45

    RE: Provide full support for SQLite database file as OneDrive data source

    Would really like this one!

    Paul Chehowski's profile image Profile Picture

    7f062158 a8e1-4ac8-8cf9-22ca7a678256 on 05 Jul 2020 23:18:06

    RE: Provide full support for SQLite database file as OneDrive data source

    Native support for SQLite 3 would enforce the use of PowerBi inmy company, as many apps are collecting data using PoweBI nowadays.

    Paul Chehowski's profile image Profile Picture

    89d7a595 d626-477f-b4e3-9cbc5ff66b75 on 05 Jul 2020 23:09:32

    RE: Provide full support for SQLite database file as OneDrive data source

    I found a workaround to connect to Sqlite.

    http://biinsight.com/visualise-sqlite-data-in-power-bi/

    Paul Chehowski's profile image Profile Picture

    8f7154c4 3386-4721-b6ab-35e450a24812 on 05 Jul 2020 23:06:04

    RE: Provide full support for SQLite database file as OneDrive data source

    Seria sensacional essa implementação. Além do PBI conectar nativamente com SQLite sem precisar instalar drives para o ODBC; seria muito interessante sincronizar isso pelo OneDrive. Será que já não é possível usando o O App de fluxo de trabalho da Microsoft?

    Paul Chehowski's profile image Profile Picture

    bf7f6a93 182a-44a5-98d1-fcc24370921e on 05 Jul 2020 22:49:10

    RE: Provide full support for SQLite database file as OneDrive data source

    Is this still not supported?

    Paul Chehowski's profile image Profile Picture

    9255c7e4 3c91-4521-ac11-487c516f5af5 on 05 Jul 2020 22:37:07

    RE: Provide full support for SQLite database file as OneDrive data source

    I have a Python web scraper that I'd like to be able to funnel its results that are easily placed in a sqlite database file into a Power BI dashboard as an interface with the database, would be nice to not have to build a database viewer :P

    Paul Chehowski's profile image Profile Picture

    cc95b7ae 136b-4f8e-b637-2ff29795e187 on 05 Jul 2020 22:35:54

    RE: Provide full support for SQLite database file as OneDrive data source

    I would like SQLite for Spiceworks too.

    Paul Chehowski's profile image Profile Picture

    c4f5f12a 6e4e-446d-a319-2a405f4a2dc1 on 05 Jul 2020 22:29:30

    RE: Provide full support for SQLite database file as OneDrive data source

    Microsoft EFCore/AspNetCore are supporting SQLite natively for app data / logging. Would be great to see PBI embrace that cross-platform community. I want to visualize SQLite data in PowerBI!

    Paul Chehowski's profile image Profile Picture

    0e0e0291 6f01-4656-a4c0-14420da2397e on 05 Jul 2020 22:13:11

    RE: Provide full support for SQLite database file as OneDrive data source

    Please! Spiceworks uses this type of database - and a lot of IT Pros use Spiceworks to track tickets.