Results 1 to 3 of 3

Thread: Pastel and Pervasive SQL to PowerBI

  1. #1
    New Member
    Join Date
    Aug 2019
    Location
    Hermanus
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pastel and Pervasive SQL to PowerBI

    Im using Excel and lately PowerBI to query tables in Pastel. Its incredibly valuable to be able to see our business visually.

    My question relates to the 32 / 64 bit incompatibility which is giving me some headaches.
    I access Pastel via an ODBC source (32 bit, as PSQL is 32bit).
    Thus the 32 bjt PowerBI has to be installed to be able to use a 32bit data source.

    Problem is, it crashes erratically and often.

    When I do a data dump to excel and access the same data with 64bit PowerBi, it’s stable.

    My model uses the “history lines” table (about 500’000 lines) and the “supplier master” and a few other smaller tables.

    So my question: is there anyone else doing similar analytics with live Pastel data?
    If so, do you have any advice to my problem? Or possibly a total different strategy to visualize Pastel data in a live environment?

    Thanx Marius

  2. #2
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    21,945
    Thanks
    3,169
    Thanked 2,566 Times in 2,164 Posts
    Blog Entries
    12
    It might be Pervasive that is causing the problem...

  3. #3
    Bronze Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    187
    Thanks
    0
    Thanked 33 Times in 29 Posts
    Maybe using MS Access? Create the linked tables (not imported) in an Access db with PVSW 32 bit odbc engine, define your primary keys, and check you have the right data. You can use windows task scheduler to execute a VBS script at a desired frequency to refresh the Access databases without having to go into it manually and refresh the data. Draw the power BI query off the access db.

    There are 64 bit ODBC drivers, but only for the client server versions of PVSW - quite an expensive upgrade path if you only running workgroup.

Similar Threads

  1. [Question] Pervasive Error 161 - Pastel Express 14
    By Kare@kchaccounting.co.za in forum Accounting Forum
    Replies: 1
    Last Post: 04-Feb-19, 12:08 PM
  2. Adding documents to Pastel with pervasive SQL
    By sylvia1312 in forum Accounting Forum
    Replies: 0
    Last Post: 29-Aug-17, 11:00 AM
  3. Pastel Partner Database - Pervasive
    By Riandwelm in forum Accounting Forum
    Replies: 1
    Last Post: 29-Mar-17, 03:22 PM
  4. At last! Pastel's Pervasive SQL to be replaced by MS SQL!
    By Neville Bailey in forum Accounting Forum
    Replies: 8
    Last Post: 16-May-16, 08:51 AM
  5. Pastel Xpress Startup - Pervasive
    By Malcolmw in forum Accounting Forum
    Replies: 5
    Last Post: 15-Dec-15, 11:25 AM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •