The following example demonstrates how to create a new dashboard parameter and pass it to a custom SQL query. In this example, the dashboard parameter is passed to the custom SQL query parameter's ...

Power Query is great for filtering data before it gets loaded into Excel, and when you do that you often need to provide a friendly way for end users to choose what data gets loaded exactly. I showed ...

Power Query is great for filtering data before it gets loaded into Excel, and when you do that you often need to provide a friendly way for end users to choose what data gets loaded exactly. I showed ...

I am running a query in Excel that I want to prompt the user to enter in a date range. I am using the "between" value. Everytime I enter in a date, it errors and says "SQL data type out of range ...