Assistance requiring approach to a project

based on the requirements you you said above :

API Data Retrieval and Incremental Refresh:
If the data fetched via APIs doesn't support query folding, you won't be able to use Power BI's native incremental refresh feature, which relies on query folding.
but you can implement your own incremental refresh logic within your data retrieval process from the API. This involves storing the last refresh timestamp and only fetching new or updated data since the last refresh. You would then append this data to your existing dataset in Power BI.
this requires more manual effort, it's a possible workaround for implementing incremental refresh with non-folding data sources.
Live Streaming Dashboard:
Power BI doesn't offer native support for live streaming dashboards with data updated in real-time. but you can use streaming datasets in Power BI to achieve near real-time updates. Streaming datasets allow you to push data to Power BI using APIs.
Embedding Reports for Client Access:
Power BI Embedded is a suitable option if you want to embed Power BI reports directly into your client's application. This option provides seamless integration with your application and allows you to control user access and permissions.
also, you can use power bi pro or premium per user (PPU) licenses to create reports and dashboards, and then embed them into your client's application using the "Embed report" option. This approach also requires sharing the report with your client and managing user access.
Regarding your query about row limits in incremental refresh:
If the number of rows updated during an incremental refresh exceeds the limit specified in your power bi service plan (i think 150 million rows for Power BI Pro), the refresh will fail.
for this , you may need to optimize your data retrieval process, filter unnecessary data, or consider upgrading to a higher-tier service plan with higher row limits.

If this helped, Follow this blog for more insightful information about data analytics
https://analyticpulse.blogspot.com/
Please Subscribe AnalyticPulse on YouTube for future updates:
https://www.youtube.com/@AnalyticPulse
Please subscribe CogniJourney On Youtube For Daily fun facts:
https://www.youtube.com/@CogniJourney