Querying SQL Server Data in Excel with a Parameter

preview_player
Показать описание
Learn how to query SQL Server Data in Excel with a Parameter from Rich Bendickson of Dashboard Gear.
Рекомендации по теме
Комментарии
Автор

This is not really querying with a parameter, it's filtering AFTER querying

byteseq
Автор

Thanks for the video! IS it possible to call a stored procedure with parameters?

aamirghanchi
Автор

Very intrsting. Would you happen to post another video on how to connect parater to a cell ?

haim.zara.ivanov.
Автор

What if I have multiple rows of data that I want to search against the sql table? I would I go about this?

zj
Автор

Hi Did you do the next video as I cannot find it?

brucetedder
Автор

Very helpful. A link to the next video in the series would be helpful. I'm looking how to call a stored procedure using these parameters.

JustAGuyYaKnow
Автор

Hello, this is really helpfull. Sorry, where is the next video from this series? I need to connect the Parameter in Power Query to a cell in Excel. Thanks!

alvaromdp
Автор

Querying SQL Server Data in Excel with a Parameter can you send me the next link

ashokkumar-ebdw
Автор

The problem i ve is that my data is so big it can't even be loaded to excell..

Kylian
Автор

The title is misleading. You are not affecting the sql query at all, you are only filtering AFTER more data than necessary had been pulled already.
I was expecting you showing how to use a parameter as part of the sql query itself.

BuckstarrZ
Автор

This is horrible! Are you really using macros? There are several other YouTube videos that show how todo this without using 1970s macros. Really? Macros?

Jahspecs
join shbcf.ru