Before being able to run REST APIs to do specific tasks programmatically in Dynamics 365 for Finance and Operations (hereby known as D365FO), the application needs to be able...
2019-06-07
308 reads
I get asked this question all the time in my work as I am the BI consultant in Dynamics 365...
2018-09-25 (first published: 2018-09-12)
2,056 reads
If like me you thought “Hey, it’s a new feature, I can finally create reports in powerbi.com service and then...
2018-02-01
949 reads
We, BI professionals, sometimes take for granted that we can access the database of an ERP system quite easily, especially...
2017-07-29
712 reads
Management Reporter is easy to use to create Management Reports and it does not require a developer to do it....
2017-07-16
428 reads
Well, hello. It has been more than three years since my last blog, since then I have been really busy...
2017-06-30
570 reads
There are some cases when you need to use a PIVOT function in SQL but you cannot use a CTE....
2014-06-04
1,235 reads
Why are there multiple rows for each item in the Demand Forecast Table in Microsoft Dynamics AX 2012? This is...
2014-05-28
717 reads
Are you confused by how user roles in AX 2012 are integrated with Management Reporter roles? Have problems adding or...
2014-05-23
841 reads
I was just trying to gauge my BI knowledge level the other day and decided to chart it for visibility....
2014-03-26
559 reads
By Ed Elliott
All Spark Connect Posts Introduction There have been quite a few changes in the last...
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
This is a quick blog post, mainly so I have the code available if...
I'm using PowerQuery in Excel on my desktop. (Yeah, I know you can do...
Here's my data... I am trying to return total days in status for each...
Here's my data... I am trying to return total days in status for each...
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers