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