Passing the Value of an Excel Cell as a Parameter to a SQL Server Query

preview_player
Показать описание
Join Rich Bendickson of Dashboard Gear and learn how to pass the value of an Excel Cell as a parameter to a SQL Server Query.
  1. Dashboard Gear
Рекомендации по теме
Java is ALWAYS 0:05:22

Java is ALWAYS Pass By Value. Here's Why

Pass by value 0:07:09

Pass by value and Pass by reference (Animated)

[c][explained] Demystifying Pointers 0:05:46

[c][explained] Demystifying Pointers — Pass by Value vs. Pass by Reference

Passing by value 0:02:18

Passing by value vs reference EXPLAINED

Pass By Value 0:26:02

Pass By Value and Pass By Reference In Java | Java Tutorials

Passing Arguments by 0:03:07

Passing Arguments by Value in Java

Java Programming Tutorial 0:04:20

Java Programming Tutorial 80 - Passing by Value or Reference

C Programming Tutorial 0:05:58

C Programming Tutorial 96 - Passing by Value vs Pointer

Ch 5 2 0:18:13

Ch 5 2 SwiftUI Lists and Passing Data Between Views (To Do List w/SwiftData app)

C++ pass by 0:04:17

C++ pass by VALUE vs pass by REFERENCE? 📧

C++ Pass by 0:10:18

C++ Pass by Value, Reference, Pointer Explained

8.6: Pass by 0:07:45

8.6: Pass by Value vs. Pass by Reference - Processing Tutorial

pass by value 0:17:58

pass by value VS pass by reference | call by sharing in JavaScript

Should I pass 0:10:45

Should I pass by const reference or by value?

Java is pass/call 0:08:23

Java is pass/call by value or pass/call by reference [MOST IMP. JAVA INTERVIEW QUESTION]| ode Decode

C++ Functions Pass 0:11:24

C++ Functions Pass by Value or Reference

parameter passing techniques 0:17:34

parameter passing techniques call by reference and call by value result

C++ Tutorials - 0:03:24

C++ Tutorials - Passing by Value VS Passing by Reference

#037 [JAVA] - 0:10:02

#037 [JAVA] - Passing Objects to Methods (by Value vs by Reference / Passing Objects as Arguments)

parameter passing techniques 0:07:34

parameter passing techniques call by value

Pass By Value 0:05:53

Pass By Value And Pass By Reference in C++ | C++ Programming Tutorials For Beginners 39

Understanding Passing by 0:13:17

Understanding Passing by Reference or Value in JavaScript

Excel VBA Topic 0:10:28

Excel VBA Topic 4.3 - Passing By Reference vs Passing By Value

What is the 0:02:13

What is the difference between Pass by Value and Pass by Reference Parameters?

Комментарии
Автор

Finally it works, but some of the string you enteted like & "' was already there?

treebeard....................
Автор

Excellent explanation. I searched for a video like this in my language, but couldn't find anything. Your video helped me a lot. Thank you!

IngridCentioli
Автор

I did all the steps same but getting Run-time error '1004': Application-defined or object-defined error. Any idea what could be happening?

VatsalSingh
Автор

Run-time error '1004': Application-defined or object-defined error

MostafaElgohary-vwtp
Автор

What if I want to let the PBI end user to input the companyCode value via any dashboard field then they can dynamically refresh the report as such. I can do that already in Excel, just wondering if I can via PBI. Please advise.

jingiwalla
Автор

This doesnt work for where you want to past text as the value, as SQL needs the ' ' either side of the value, but using that in excel . If anybody can tell me how I accomodate that in VBA as im a beginner :(

jimmerding
Автор

Great work around, thanks. I was so excited to see excel making it easy to connect to an sql database, and power query had something called parameters. I thought it was going to let me use the parameters in the query. Frankly, if you have to apply filters AFTER your app gets the data from SQL, it's wrong. Common Excel, you're so close!

jonathanwilson
Автор

Great video. How would I reference a date value from E3 in the query?

MIsForMoto