Project Scope
The developer will:
Connect to 3-4 REST API endpoints (POST):
DetailedSalesByProductReport/GenerateReport
OnHandReport/GenerateReport
AppointmentReport
Implement Power Query (M) scripts to:
Pass parameters (API key, start/end dates, company IDs)
POST JSON bodies dynamically
Handle multi-location customers (SelectedCompanies array)
Build a Power BI data model with:
Sales line item table
Current inventory table
Company/store dimension (if needed)
Configure Incremental Refresh so historical sales data is preserved.
Create a clean .pbit template that prompts users for:
API Key
Selected Store IDs
Date range
Create 4–6 basic dashboards:
Sales by day
Sales by store
Top products
Inventory on hand
Category/Brand performance
Ensure the model can be published to Power BI Service and refreshed using a gateway.
Deliverables
Final .pbix file
Final .pbit template
M code for both API queries
Instructions for our customers on how to:
Enter their API key
Refresh data
Publish to Power BI Service
Requirements
Strong Power BI experience (M language, data modeling)
Experience calling REST APIs with POST from Power Query
Experience with Incremental Refresh
Must deliver a clean, production-ready template
Apply Now
Apply Now