Query – Page 3 – Pardaan.com

Monitoring Power Query Memory Usage With Query Diagnostics In Power BI

In the April release of Power BI Desktop the Power Query Query Diagnostics feature was enhanced so that you can now return performance counter data. As the blog post says: When you run performance counters, every half second Power Query will take a snapshot of resource…

28 May 2020

Dynamics NAV & BC Tips & tricks

Video: Hacks with the Query String

I finally got my youtube setup running, here’s the first video, Hacks with the Query String. Source : Hougaard.com Read more...

27 May 2020

Dynamics NAV & BC Tips & tricks

Using the power of queries to bring some smartness into Business Central

Currently there’s a lot of talk about Business Central performance. Microsoft has released and is releasing guidelines, tools about mechanisms to program for performance, analyse and monitor performance. At the same moment there’s also discussions going on on public and private fora about database size and…

19 March 2020

Data & Analysis

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…

17 March 2020

Dynamics NAV & BC Tips & tricks

How do I: Create a report based upon a query?

Performance wise it can be very interesting to use query objects as a data-source in a report (or any other object). Imagine you want to create a report that shows the top X records from a table, let’s say for example Customers, then creating a report…

19 February 2020

Dynamics NAV & BC Tips & tricks

How to: Join Data Items to Define the Query Dataset in Microsoft Dynamics 365 Business Central

Query objects can also perform calculations on data, such as finding the sum or average of all values in a column of the dataset. Business Central query objects enable you to retrieve records from one or more tables and then combine the data into rows and…

6 February 2020

Dynamics NAV & BC Tips & tricks

Putting Queries to Use in Business Central

We’ve had query objects for a while now – since NAV 2013 (I think). In theory they sound great, link a bunch of tables together, aggregate some columns, get distinct values, left join, right join, cross join – executed as a single SQL query. Source :…

17 January 2020