Posted inDynamics NAV & BC Tips & tricks
3 Ways to GET a Record in Dynamics 365 BC
Did you know that there is more than one way to get a single record in Microsoft Dynamics 365 BC? Source : Simplanova Read more...
Posted inDynamics NAV & BC Tips & tricks
How to get field values from other extensions/apps in Business Central without adding dependencies property
Today I would like to talk about how to get field values from other extensions/apps in Business Central without adding dependencies property. As you might know, when we develop for Business Central, we need to download the symbol file first. These contain the source code of…
Posted inDynamics NAV & BC Tips & tricks
Get ID from Table
This week I was goofing a bit with archiving data to Cosmos for a project when I needed to have the ID of a table from a variable. This has always been a challenge in Navision. Source : Marije Brummel | Business Central, Azure & More…
Posted inData & Analysis
“In the Previous” Date Filters In Power BI/Get&Transform/Power Query
The Query Editor in Power BI/Excel Get&Transform/Power Query has a number of built-in ways to filter data in date columns relative to the current date, such as the “In the Previous” option. However these filters behave in a way I find non-intuitive (and I’m not alone)…
Posted inDynamics NAV & BC Tips & tricks
Get next object version number
Every developer has sometimes the issue: What is my next version number for the new object ? If there is a couple of developers working in the some database, you’ll need a kind of a version control. I’ve developed a page, which calculates the next version…
Posted inData & Analysis
Query Folding And Writing Your Own SQL Queries In Power Query/Power BI/Excel Get & Transform
When you connect to a relational database like SQL Server in Power BI/Power Query/Excel Get & Transform you have two choices about how to get the data you need: Bron : Chris Webb's BI Blog Lees meer...
Posted inData & Analysis
Power Query/Get & Transform: The Future Of Data Loading In Excel
Last week, Dominic Petri shared a link on Twitter that contained some important news from Microsoft: as of the March release of the Office 365 click-to-run version of Excel 2016, the old methods of loading data into Excel will be replaced by the newer “Get &…