How to Use GROUP BY and HAVING Clause in SQL
When working with SQL, you’ll often need to group data to analyze and summarize it. The GROUP BY statement makes this possible by allowing you...
How To Add FinancialDimensionValue table from D365FO to Fabric
If you are moving your data from Microsoft DataLake or BYOD to Microsoft Fabric, you will notice that some fields are missing in Fabric. This...
How to Use GROUP BY and WHERE Condition in SQL
In this post, I’ll explain how to use GROUP BY and WHERE condition in SQL, provide examples, and show you the syntax step by step....
Azure Synapse Link: Failed to fetch TypeError
If you are using Microsoft Fabric with D365 Finance & Operations, you could be getting the following error: Failed to fetch TypeError: Failed to fetch...
Microsoft Fabric and D365 F&O: 13 Things to Know
If you’re using Microsoft Dynamics 365 Finance and Operations (or any other business software), you know how important data is to making the right business...