Learn how to connect Smokeball to Power BI Desktop by Microsoft, to create highly customised and detailed reports from your data in Smokeball.
This integration is in beta
The Smokeball and Power BI integration is currently undergoing beta testing with a small number of users.
About Power BI
Power BI is a Microsoft business analytics tool that helps users visualise, analyse, and share data insights. It can connect to various data sources to create interactive dashboards and reports. It also offers AI-powered insights (via Microsoft Copilot).
Learn more about Power BI from the Microsoft website.
You can create dashboards and reports using the following data points in your Smokeball firm:
- Activities
- Contacts
- Expenses/Disbursements
- Fees
- Invoices
- Matters
- Matter Types
- Payments
- Roles
- Staff
- Transactions
Important Note
This article will guide you on how to install the Smokeball data source in Power BI Desktop. Since Power BI reports can be highly complex, building custom reports and dashboards falls outside the scope of Smokeball Support.
Connecting Smokeball to Power BI
Only staff members with the Firm Owner role can connect Smokeball to Power BI.
-
For best results, close the Smokeball desktop app before you begin.
-
Open and install the SmokeballPowerBIConnectorSetup-production.msi file to your PC.
-
Open the Power BI Desktop program.
-
From the Home page, select Get data from other sources.
-
In the Get Data window, type "Smokeball" in the search field at the top.
-
Click on Smokeball (Beta) (Custom) and select Connect.
-
Acknowledge the message on the Connecting to a third-party service window by selecting Continue.
-
Select your Smokeball region from the drop-down menu, then select OK.
-
Select Sign in.
-
A new window will open. Select your firm region, then click Continue.
-
Enter your Smokeball login details, then click Sign in.
-
Once you have successfully signed in, you will be brought back to the previous window. Select Connect.
-
In the Navigator, tick the data points you wish to load. The Preview pane on the right-hand side will update with a sample of data from your Smokeball firm that you can analyse in Power BI.
-
Select Load. Power BI will start downloading all selected data from your firm.
-
The report is now ready for building, with your data available from the right-hand pane.