What is Power Query? Power Query is an Microsoft tool for Excel that is used to do the following: Connect to a data source Extract data from source Transform the extracted data Load the transformed data into Excel This functionality is called ETL (Extract, Transform and Load). Why use Power Query? Excel already has another […]
Introduction to Excel Power Query aka Power BI Query Read More »
This data comes from Statistics Canada. Statistics Canada download pages often provide the opportunity to modify the data structure and content before it is downloaded. For example clicking on the [Add/Remove data] link provides options select different groupings of data by provinces. I choose to group data by provinces. I also limited the content to
Excel Power Query tutorial using Canadian potato production statistics Read More »
Power Query is quick and easy way to scrape HTML tables on web pages. Here is step by step on getting multiple tables from Wikipedia article and appending them into one Power Query Excel table. The Wikipedia article List of national and international statistical services has multiple tables with lists of countries’ statistics agencies and their website
Use Excel Power Query to scrape & combine Wikipedia tables Read More »
Do you want to create a Power BI Report that gets a daily scheduled refresh of data from a Sharepoint csv file? The first step is to create your Power BI report in Power BI Desktop using the Sharepoint csv file as data source. In Power BI Desktop use Get Data – File – Sharepoint Folder
How to schedule Power BI dataset refresh Read More »
Excel Power Query can make a connection to MySQL database but requires that you have a MySQL Connector/Net 6.6.5 for Microsoft Windows. Instructions for that on Microsoft site. Once you have the connector you can get MySQL db table data into your Excel file using Power Query in two ways. The method you select will
Power Query MySQL database connection Read More »
