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.
How to use a combination of Cards and Bookmarks to filter other visualizations in Power BI.
How to handle REST API queries in Power Query and Power BI where both Basic Authentication and API Tokens are required.
How to query a REST API using Power Query and process the paginated results when the number of pages is either known or unknown.
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.
How to display the last modified date of the underlying source Excel data file used in a Power BI report.
How to create a custom date table and year, quarter, month hierarchy in Power BI using Power Query.
Tips and tricks learned from using Microsoft Power Query for Excel including performance improvements, creating total rows and running totals, handling empty tables, and filtering using named range values.