think about IT

The Microsoft Power BI team recently introduced dataflows. I’m currently in the process of researching this exciting new technology and came across this article, from Adi Regev , that I wanted to share with you: Introducing: Power BI data prep with dataflows In the modern BI world, data preparation is considered the most difficult, expensive, and time-consuming task, estimated by experts as taking 60%-80% of the time and cost of a typical analytics project. Some of the challenges in those projects include fragmented and incomplete data, complex system integration, business data without any…

When you need to design a layout for a report, using VSCode, when creating an extension, as you might already know, you have the choice between using Report Builder and Visual Studio. And you can use both of them at the same time, which enables you to combine the advantages of both environments when designing RDLC report layouts. First you need to download and or install Report Builder and Visual Studio . You can find the prerequisites here : Report Builder for SQL Server 2016 Visual Studio 2017 with Microsoft Rdlc Report Designer for Visual Studio installed. Normally, Report Builder…

Here I’m again, ready to continue this post ( http://thinkaboutit.be/2019/01/how-do-i-create-a-document-report-and-layout-in-vscode-part1 ). At this moment we have a dataset that fetches information from two tables: a header and a line, that are joined together via the  DataItemLink and PrintOnlyIfDetail properties. Now it’s time to add a layout. Now, a report can have none, one, or multiple layouts. Using the ProcessingOnly report property, you can say that the report does not have a layout, and will only execute the AL-code in the triggers of the report and the dataitems. Furthermore,…

In my blog post: How Do I : Create a Report, and layout, in VSCode? I explained the basics on how you can create a simple report for Business Central. In this post, and due to many requests, I will explain how you can get started to create a document report. What is a document report you might think? Well, a document report is typically a report that you print or generate in pdf to send to a third party, like for example an invoice or a credit note to a customer or a purchase order confirmation to a vendor. Typically a document report fetches information from multiple tables. In business…

December is a huge month for us in terms of accessibility. With this release, the entire product supports screen readers, keyboard navigation and high contrast for both report consumption and report creation. We are also previewing one of the most asked for features related to Q&A, support for live connect! We also have lots of smaller improvements across the product, such as customizable tooltips for buttons and a larger DAX formula bar. https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-december-2018-feature-summary/ Here’s the complete list of December updates: Reporting Smart…

Some time ago I mentioned a brand new product: SQL Operations Studio. Its feature set was small and aimed mainly at the developer persona. Now, recently, SQL Operations Studio was rebranded as Azure Data Studio. Although they’re effectively the same thing currently, you do need to install Azure Data Studio separately from your existing sqlops install. You can install the new Azure Data Studio after downloading it from here: https://aka.ms/getazuredatastudio . The docs also include a helpful section,  Move User Settings , that will help you migrate any custom settings you don’t want to lose from…

https://community.dynamics.com/business/b/businesscentraldevitpro/archive/2018/12/20/developer-preview-december-2018 This December marks the two year anniversary of the very first AL Developer preview back in December 2016 . And we want to use this opportunity to say “Thank you!” to all the partners that have dived into AL, installed the Visual Studio Code, and AL Language tools. We are now at 47K downloads, and an impressive 20K installs and the numbers keep growing. Thank you for providing us with feedback on GitHub, submitting  Ideas , bugs, as well as enhancements to make the product even…

The new modeling view for Power BI Desktop is here! See the announcement in the November Power BI Desktop feature summary . It is designed to work with enterprise datasets that grow in complexity. Such datasets can easily contain over 100 tables. Here is a summary of what you can do with the new modeling view. Break out complex models by subject area into separate diagrams. Multiselect objects and set common properties in one go. View and modify properties in the properties pane. Set display folders for simplified consumption of complex models. This animation shows some of what…

Almost every time I deliver a training, presentation, webinar,… someone always asks me, what is this magic you use to zoom in and out and annotate? Well, the answer is: ZoomIt, by Mark Russinovich. ZoomIt is a screen zoom and annotation tool for technical presentations that include application demonstrations. ZoomIt runs unobtrusively in the tray and activates with customizable hotkeys to zoom in on an area of the screen, move around while zoomed, and draw on the zoomed image. Download it here! or Run now from Sysinternals Live . ZoomIt works on all versions of Windows and you can…

Almost every time I deliver a training, presentation, webinar,… someone always asks me, what is this magic you use to zoom in and out and annotate? Well, the answer is: ZoomIt, by Mark Russinovich. ZoomIt is a screen zoom and annotation tool for technical presentations that include application demonstrations. ZoomIt runs unobtrusively in the tray and activates with customizable hotkeys to zoom in on an area of the screen, move around while zoomed, and draw on the zoomed image. Download it here! or Run now from Sysinternals Live . ZoomIt works on all versions of Windows and you can…