D365FO & Power BI Pre-requisites

We just left GP and have gone live with D365FO. My goal is to customize reports/dashboards by utilizing data from D365FO and housing it in a location for user to run ad hoc e.g., SharePoint.

Also, would want to leverage Power BI capabilities for users personalized workspaces. What I am not sure how is to make the one-to-one connection between user’s personal workspaces in D365FO and power BI.

Would love to know more about what you’re asking here.

Have you seen this link? It walks through the authorization process that you would need to do for each user.

Configure PowerBI.com integration - Finance & Operations | Dynamics 365 | Microsoft Learn