Dynamics 365 Great Plains
Add a prefix to a field in Microsoft Power BI via Power Query
Adding a prefix to a field in the Microsoft Power BI Power Query is a simple process that can be accomplished quickly. Highlight the…
Tag: query
Dynamics 365 Great Plains
SQL Scripts for Microsoft Dynamics GP: Sales Invoice Query
This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics…
Dynamics 365 Customer Engagement
Fixed – Bad Request – Error in query syntax while using Xrm.WebAPI
We might get the below error while using Xrm.WebAPI. ‘Bad Request – Error in query syntax.’ One of the reasons could be that while…
Dynamics 365 Business Central
D365 Business Central : Using Query to Get Distinct Values
When working with table data, there will be times when we need to retrieve a unique record value (also called SELECT DISTINCT) from the…
Finance & Operations
Date format issue in ‘Execute a SQL Query (V2)’ logic apps – D365FO integration
I had already explained about using sql query execution in my earlier blog posts. Recently I had another issue when using date column in…