In my last project I had, once again, the task to develop an external webservice connection. The goal was to fetch orders from an external interface in dynamics nav and write back some states. In itself this is of course a simple story.
Tag Archives: Query
Views and Queries in Business Central
While reviewing options to alter existing queries, I felt trap to the fact that now queries do not need a new page to display results, but can be connected to existing List pages.
Below, highlighted are all queries connected to Customer List page.
Using Power BI Dynamic M Parameters In DAX Queries
As I’m sure you’ve guessed by now I’m a big fan of dynamic M parameters in Power BI. They’re easy to use in Power BI Desktop but what if you want to use them in your own DAX queries? Documentation for this is coming soon, but in the meantime I thought it would be useful to show the additions to DAX query syntax to support them – something you can see for yourself if you take a look at the DAX queries generated by Power BI Desktop using Performance Analyzer.
Inline Query | SQL like Queries in Business Central
Inline Query is a library that can execute SQL like Queries in Business Central AL Language. This is a small compiler in AL that compiles and executes SQL like queries in text constants or text variables.
Business Central Execute Queries from Pages
With the QueryCategory property we can execute a query object from a page (also available in Smartlists) by defining a query in AL; it is possible to declare with a comma separated list where the object can be used, in practice it is added to the list of objects published in the SmartList.
Source : Roberto Stefanetti Blog – Microsoft Dynamics 365 Business Central
Read more…
View Native Query Now Works For Analysis Services Data Sources
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.
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 utilization. This isn’t useful for very fast queries but can be helpful for queries that use up a lot more resources.