Power Query Use Data From Worksheet as Parameters

[msquared99]

I am pulling data from a database. What I would like to do is setup a few parameters in the workbook that contains the query and use named ranges to filter the data in the query.

For instance have a start and end date, service, the beginning of a billing code such as PR, CB, or FB that I enter on a master spreadsheet and power query will use those the retrieve the data.

I did find a few articles online but I get all sorts of errors and security messages.

Any ideas?

 

[Chihiro]

Have a read of post below.
https://chandoo.org/forum/threads/useful-powerquery-tricks-chihiros-notes.35658/

Basically, you need to have security setting of your workbook to be same as your database (Organizational, Private, Public).