Today Microsoft released the October 2018 update of Power BI Desktop. One of the fabulous new features that has been released is the ability to get a visual profile of your data in Power Query BEFORE you load the data. This new feature is typical of the type of development effort Microsoft is investing in with its products. MS is trying to make your life easier by helping you with the tools you need to do the job without you having to do everything yourself from scratch.
Tag Archives: Data
Can You Use Power Query In Power BI Or Excel To Write Data To A Data Source?
It is, technically, possible to use Power Query (in either Power BI or Excel) to write data to a data source; for example, here’s an old post I wrote showing how to run a UPDATE statement to update data in a table in SQL Server.
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 the current release
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 found on the internet work in more complex scenarios when the data on each sheet needs some kind of transformation before it can be combined.
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 statistics about Australian schools, one page at a time. The information presented on a typical school profile page (e.g. Burwood Public School) is as shown below.
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 by using data that comes from NAV, external sources, IoT devices and so on.
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 more detail.