Power BI, Looker and other BI tools
Solid Accounting has no built-in connector for Power BI, Looker, Sigma or any other BI tool. An earlier version of this page described one. It was never built.
Get your numbers out today
- Export a report. Every report in Reports has a PDF button and an Export menu with CSV. Power BI, Excel and Google Sheets all open CSV files. See Reports.
- Export a workbook. Reports → Accountant's Workbook... saves an Excel workbook (
.xlsx) for a fiscal year, with the trial balance, balance sheet, income statement and supporting tabs. Choose Accountant's Workbook (with GL Detail)... to include every general ledger line. - Read from the local API. On Professional and Accountant, the Local REST API Server gives a script on the same computer read access to balances, the trial balance and reports. Examples:
/reports/income-statement,/reports/balance-sheet,/trial-balance. A script can write the results to a CSV file or a database your BI tool reads. See REST API.
What to expect
The API only listens on your own computer (127.0.0.1). A cloud BI service can't connect to it directly. Run the export script on the computer where Solid Accounting is open, then send the file wherever you need it.
If a direct BI connector matters to you, email support@solidaccounting.com and tell us which tool.