Forum Discussion
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.- For simpler transformations:
Hi,
Thanks for your reply and providing me the resource.
My data is from FnO to Fabric via Dataverse as Shortcut tables.
I have few queries:
1. One of the approaches which I have checked is using a SQL Analytics EndPoint, making changes and saving it as a view (The view gets saved in OneLake).
2. For creating a calculated column, we can use the Visual Query to work on.
For creating a measure, either with transformed (can use from View) or from shortcut tables.
3. Is this approach of using SQL Endpoint and saving it as a view the best approach, where I get tables as "Shortcut Tables", over creating notebooks and running them at regular intervals.
4. On a short Note, I prefer not to use a Warehouse, since I host a Lakehouse already.
5. Kindly assst me over other methods if available, and I believe, using a notebook in the lakehouse, uses the method of loading it in a "df" and saving it as a "table".
Any assistance on this would be highly helpful.
Thanks in Advance
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.
Hi Anonymous ,
Yeah it helped me.
Thanks
Hi Ashwath_Bala_S ,
Glad to know that your query got resolved. Please continue using Fabric Community for your further queries.