
I have a requirement where, for every new customer, a SharePoint site and two lists are created automatically through Power Automate during the onboarding process. This part is already working.
Each customer site needs to display a dashboard/report built from those two lists (similar to the screenshot attached).
Since each customer has a separate site and separate lists, we want to automatically generate the report as well, instead of manually designing a Power BI report for every customer.
Is it possible to automate Power BI report creation and binding it to the newly created SharePoint lists? If so, what is the recommended approach or architecture to achieve this?
Any guidance on automating report generation in this type of multi-tenant SharePoint setup would be greatly appreciated.