Power BI Developer Needed to Build Power BI Template using Franpos API
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 tot his job