I have also attached the interactive dashboard in the App. The App is fully interactive and enables you to drilldown to your GL transactions. Attached is a screenshot of the landing page of our MyBI App showing you all the BI reports auto generated. It works out of Excel and is delivered to you and your users through a cloud solution (Dropbox). We have developed BI Apps for Pastel that auto generates management accounts and much more from your PSQL database on a daily basis. Looking at your reasons I want to suggest to you to first have a look at BI tools available that is specially built for Pastel Partner / Xpress. I also found that I needed more than the standard reporting for my businesses to assess my Pastel database. Thank you for your detailed response Michelle. Perhaps I don't have to connect to the pervasive database after all. Getting Started with Sage Intelligence and Power BI. I've just found this video which may help and am about to watch it. But I'm afraid I'm still stuck at the starting line. Another example: Power BI P&L and Balance Sheet Dashboard - YouTube It's just extremely powerful for building Finance Reports. There's a huge amount of support for PowerBI. If I phone Sage Pastel, even though I pay them R10k a year to 'support me' they tell me that Sage Intelligence support is not included. It's easier to learn PowerBI than Sage Intelligence / Excel from what I can make out (and once you have PowerBI skills you can use them on any datasource, not just Pastel) My users just need to login to my PowerBI web page and they can see all our company reports (including those - hopefully - from Pastel) I can build beautiful and interactive reports - rapidly (example of a Beautiful Income Statement) May I ask, why are you trying to connect to Power BI?Hi Alec, why? I've got several reasons why I'd like to use PowerBI You can then select your tables and fields that you need and write the report in PBI. If prompted for credentials to access DB, either use your windows username and password, or try administrator with a blank password. When you click connect, all the odbc db connections you are running on your system will show up - select the Pastel ODBC database you have setup.

Open PBI desktop, select get data, select other/all then select ODBC. you will need to ensure that you are running 32 bit PBI to see the 32bit odbc datasources. When you download BPI from MS website, select advanced download and select the PBIDesktop.msi, not the PBIDesktop_圆4.msi file. Once you have the database created, you can work in PBI.ĭue to the fact the Pastel is running PVSW9 or 10, there is no 64 bit odbc connector (only available from pvsw 11 onwards).

Start - Run - PCC Expand to your pc, databases, add new db, add name and browse to pastel db on server. You are going to need to setup the database in PCC first. As far as I know, Power BI doesn't have a direct PVSW connector.

Pervasive psql v13 download