Data – Page 12 – Pardaan.com

Business Central W1 Docker image with data

I’m using Docker quite regularly (well, if you find “pulling an image twice a day” is regular) .. and I have been using mostly these two repositories according my needs (for more info, look here): “bcinsider.azurecr.io/bcsandbox-master” for the very latest version (the future release) “microsoft/bcsandbox” for…

6 September 2018

Data & Analysis

Combining Data From Multiple Worksheets In The Same Excel Workbook Using Power BI

It’s very common that you need to combine data from multiple worksheets in the same Excel workbook when you’re using Power BI or Power Query/Get&Transform in Excel. Indeed a lot of people have blogged about how to solve this problem, but none of the solutions I’ve…

17 July 2018

Data & Analysis

Using Power Query for Extracting Non-Tabular Data from Web Pages

Ivan: I recently moved to Australia with my family. While searching for a place to live I had to look for a good pair of suburb and school. I found interesting data at https://www.myschool.edu.au/. However, there is no option to compare schools. It just gives some…

12 July 2018

Dynamics NAV & BC Tips & tricks

Using SQL Data Sync with Microsoft Dynamics NAV on-premise and Azure SQL Database

In many Microsoft Dynamics NAV implementations we have situations where the NAV database is often “coupled” with a second database for business intelligence processing or other data manipulations/analysis. Often we use this scenario for handling Power BI data warehouses in the cloud (Azure SQL) that work…

29 June 2018

Dynamics NAV & BC Tips & tricks

How to Load Data from a Folder in Power BI

One powerful Power BI feature is the ability to import data from multiple files located in a folder. To be able to do this, the files must have the same schema (same number of columns, same datatype, etc.). In this article, we will describe this in…

30 May 2018

Data & Analysis

Working with Pivoted Data in Power BI

Oftentimes we have data in a format that is not suitable for creating visualizations in Power BI, for example, pivoted data. However, we still want to work with that data. Let us explore this in more detail. Suppose we have a table of data representing units…

24 May 2018