Grand totals need to be retrieved in PowerBI without aggregation

I am looking for a PowerBI expert who can help me retrieve grand totals without aggregation from a web API data source. The ideal candidate should have experience working with web APIs in PowerBI and be able to handle data refreshing.

Requirements:
- Experience working with PowerBI and retrieving data from web APIs
- Ability to handle frequent data refreshing, if needed
- Proficient in creating visuals and tables in PowerBI
- Familiarity with retrieving grand totals without aggregation in PowerBI

Please include examples of previous PowerBI projects you have worked on and your experience with web APIs.