Hi everyone,
I’ve had several people reach out asking for help getting started with Power BI, so I wanted to share a Power BI template file to help you get up and running quickly. This includes the following reports:
- Created Tasks (year over year)
- Completed Tasks (year over year)
- Open Tasks by Date
- Reserved Parts
- Parts Summary
- Cycle Count Variance Report
- POs
You can download the template here:
https://drive.google.com/file/d/1PscvjbV7SXaNhTRNb1SmH5cjMkjHJcut/view?usp=sharing
*Click on the download icon in the top left.
After downloading, simply update the parameter to connect it to your company’s Limble account:
Update with Company Information
1. Open the report and click on "Transform Data"
2. Click on "Limble_API_Token"
3. Click on "Manage Parameter"
4. Replace "Current Value" with your base64 encoded value
Need to create your base64 encoded value?
Open PowerShell (on a windows computer) and run the command below. Replace CLIENT_ID and CLIENT_SECRET with your Limble API credentials.
[Convert]::ToBase64String([Text.Encoding]::UTF8.GetBytes("CLIENT_ID:CLIENT_SECRET"))
For step-by-step guidance, please refer to the Limble Help Center article:
Share your ideas and problems!
If you’ve built something cool or have issues setting things up and want some help please consider posting in the Limble Community. The more we share what’s working and what we are struggling with, the more we can learn from each other and continue improving together!
