1

I have a Python -based website hosted on pythonanywhere.com. The website asks for feedback from the user and stores input in sqlite3.

How do I access the website's database in Microsoft Power BI (preferably real-time or periodic otherwise) to display the results?

user4157124
  • 2,809
  • 13
  • 27
  • 42
Musaib Jan
  • 121
  • 8
  • Not sure how to do this using Power BI, but if you can screen-scrape the site, Python + BeautifulSoup OR Python + Selenium, would almost certainly do the job for you. Just a thought. – ASH Apr 05 '22 at 14:51

1 Answers1

1

This is possible. You need the ODBC driver and gateway on your machine. The same user needs to be logged on your machine to make it work. See. check https://community.powerbi.com/t5/Power-Query/connecting-a-SQLite-database/td-p/224205

AdB
  • 11
  • 1
  • 1
    While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. - [From Review](/review/late-answers/32856125) – abdo Salm Oct 08 '22 at 23:09