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.
Power Query
Using Cards To Filter In Power BI
How to use a combination of Cards and Bookmarks to filter other visualizations in Power BI.
Accessing REST APIs with Basic Auth and API Key in Power Query
How to handle REST API queries in Power Query and Power BI where both Basic Authentication and API Tokens are required.
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.
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.
Custom Power BI Date Tables Using Power Query
How to create a custom date table and year, quarter, month hierarchy in Power BI using Power Query.
Microsoft Power Query for Excel Tips and Tricks
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.