

Then click in the cell (1 below), select data (2), from Table/Range (3). The first thing to do is set up a single cell table that contains the date of the orders to extract. However there may be people that want to do it this way for what ever reason. Note: There are other ways to do this, such as loading all records into Power Pivot and extracting them from there on demand. When I refresh the query in Excel, the results table is updated with all the orders from the database for the selected date.

In the example below, I have set up a single cell in Excel that contains a date which is then passed to Power Query. I am going to demonstrate the concept using the Adventure Works database. Sample Scenario – Extract Invoices for Selected Date I have written previous articles about this principle at but thought it would be good to blog about how simple it is to do this.
DYNAMIC MYSQL QUERY ODBC EXCEL HOW TO
I was delivering training yesterday in Sydney and one of my students (Stephane) asked me how to pass a parameter from Excel to Power Query. I’m super excited what the future holds for this fantastic product, and it just keeps getting better and better. My last 5 live training courses in Australia have all had record numbers of participants, and my current semester of live online training (Supercharge Power BI) has 34 active participants. I have been delivering Power Pivot/Power BI training for almost 4 years now and the demand has never been greater. Side Story: Power BI Training Has Never Been More Popular I have been super busy with the PUG World Tour, delivering a lot of training, finalising my new book Supercharge Power BI, and also taking a couple of weeks vacation. Regular readers of my blog may have noticed I have been missing in action over the last month.

DYNAMIC MYSQL QUERY ODBC EXCEL INSTALL
The Best Way to Install Power BI Desktop.30 Reasons You Should Be Considering Power BI.Dimensional Modeling (Excel and Power BI).Foundations of Power BI – Data to Dashboard.Module 1: Foundations of Power BI – Data to Dashboard.
