Developing Dashboards from FnO Data

Hi Ashwath_Bala_S ,

Apologies for the delay in reply from our side.

You're absolutely right! Choosing the appropriate method for building dashboards from FnO in Fabric depends on several factors, particularly the complexity of your data transformations and your team's skillset.

• For simpler transformations:
  SQL Endpoint: This is a great option for straightforward operations like filtering, aggregating, and joining data. It's user-friendly and doesn't require coding knowledge. However, its capabilities are limited for complex scenarios.
• For complex transformations:
  Lakehouse notebooks: If you need more advanced data manipulation, notebooks offer greater flexibility and power. You can write code to clean, transform, and enrich your data before using it in Power BI. However, this approach requires coding knowledge and might have a steeper learning curve.
  
  

Additional Reference:
Microsoft Dynamics 365 - Finance & Operations AND Fabric AND PowerBI

Hope this is helpful.