If you’re familiar with the topic of query folding in Power Query, you’ll know that the View Native Query right-click option in the Applied Steps pane of the Power Query Editor can be used to show the native query that is run against the data source. You may also know that there are some data sources where query folding does take place but where View Native Query remains greyed out.
Tag Archives: Analysis
Dependency Analysis Tool (ALDependencyAnalysis)
Remember this post? Probably not. Nearly a year ago at Directions US, I showed some “how did I do stuff” during a number of sessions. And it ended with a lot of feedback, which came down to: “can I have it”? So, that’s where I wrote a post “I have work to do” ;-).
The “DevOps”-part of the work is done: ALOps is available and well used :-).
But the second promise – the “Dependency Analysis”, I only completed in November 2019 – and totally forgot to blog about it. In my defense – I did explain it at NAVTechDays, and that video IS online. You can find it here: NAV TechDays 2019 – Development Methodologies for the future (This is a link to the point in the video that explains the “dependency analysis” part).
Visualising Power BI Premium And Azure Analysis Services Query Parallelism
In my last post I showed how to connect SQL Server Profiler up to a Power BI Premium dataset but I didn’t give you any examples of why this might be useful. In this post I’ll show you how you can use a Profiler trace to visualise all the queries run by a Power BI report, see when they start to run, see which ones run in parallel with each other and see what the overall time taken to run all the queries is.
SQLBits Power BI And Analysis Services Videos Now Free To View Online
SQLBits is one of the best Microsoft data platform conferences around, and last week’s event in Manchester was particularly good. As usual, videos of almost all of the sessions are available for everyone to view for free online (no registration required) here:
C/AL Source Code Analysis with PowerShell
Last Directions US and EMEA, I had the opportunity to talk about – uhm – myself. Well, not really – about my tools. It was a weird experience – but it got more attention than I ever expected.
Now, during that session, I showed a tool that I wanted to put out there for sooooo long: a way to analyze your C/AL Source Code with PowerShell.
This was actually an “let’s see what we can do and how far we can go”-challenge during our free time ;-), where the .Net part (which is the majority of the work) wasn’t done by me, although I was quite (let’s say “overly”) involved with the entire evolution of it ;-). The tool might not be completely new to you. I have been using it for quite some time to talk about some things within the product, like:
AL Code Analysis Rules (Diagnostic Descriptors) – Updated Again
I have been blogging a few times about the Diagnostic Descriptors we get when enabling code analysis. Well – yet again, we have new ones. But I’m not going to keep updating these rulesets, as Microsoft is now doing that on docs. So let me give you one more overview, and the resources to the pages on docs per analyzer.
Smart Solutions 7: Predictive analysis with Time Series, and intro to R for C/AL developers
Time Series is a topic on its own in machine learning, as it is one of the cleanest examples of predicting the future. All you need is a dataset that contains a date and a number. Time Series then uses this to predicting values for future periods.