Power Query to Access Excel Data from Current Workbook, Local File, or SharePoint
Power Query examples to access Excel data in the current workbook, local file, or SharePoint path. Data structured as a worksheet, table, or named range.
Data and Analytics
Manually Create a WordPress Database from the MySQL Client
How to manually create a WordPress database, establish a WordPress user access account, and import data from the MySQL / MariaDB command line.
Using Cards To Filter In Power BI
How to use a combination of Cards and Bookmarks to filter other visualizations in Power BI.
WordPress Database Cleanup Without Plugins (SQL Only)
Simple SQL statements to clean unnecessary overhead, bloat, and orphaned data from WordPress databases without using a plugin.
Handling Paginated REST API Results with Power Query
How to query a REST API using Power Query and process the paginated results when the number of pages is either known or unknown.
Mapping Cities in Power BI
How to render map visualizations with complex and duplicated city names in Power BI using geographical hierarchies.
Mapping Continents and Countries in Power BI
How to render both basic map and filled map visualizations in Power BI using continent and country names.
Excel Lookup Using Date Ranges and Multiple Criteria in Power Query
How to use Power Query to retrieve a value when the date from the first table exists between an effective date range in a second table.
Display Excel File Modified Date in Power BI
How to display the last modified date of the underlying source Excel data file used in a Power BI report.