how to export all data?

Follow

Zachery Kromowidjojo

• February 16, 2021 16:57

1

• 

  christopher dillon

  • February 17, 2021 08:28

  just do a backup and then transfer the .db file to the new system

  0

  Comment actions Permalink
• 

  Zachery Kromowidjojo

  • February 18, 2021 10:56

  I want to export the data in some format so i can import this in a business intelligence system to do some analysis and create custom reports. I am aware how the backup procedure works. 
  
  Also this is for the free version. For the paid version, there is central database, so that shouldn't be problem I think. 

  0

  Comment actions Permalink
• 

  D C

  • May 03, 2021 03:51

  Did anyone figure out how to export all the sales data into excel?

   

  -1

  Comment actions Permalink
• 

  Sjon Rombouts

  • September 10, 2021 21:31

  I managed to connect my power bi to Aronium with a ODBC connector *SQLlite3. So you can also connect it with Excel. Beauty is you do this once and afterwards you only refresh and all your data is in there.

  

   

  

  1

  Comment actions Permalink
• 

  D C

  • September 13, 2021 20:23

  Feel free to reach out to me if you have time and will explain, dcmpbell@gmail.com

  0

  Comment actions Permalink
• 

  Sjon Rombouts

  • September 15, 2021 20:11

  For everybody else. I managed to do this with this website!

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

  0

  Comment actions Permalink

Please sign in to leave a comment.