Hello,

I am relatively new to power query. I am trying to use a parameter to specify a table for the source of a PQ. I have found various solutions that are sort of close to what I am trying to do, but none of seems work in my case. I appreciate you pointing me in the right direction.

I have a table in excel that I specify the various tables I want to use. From that table I derive a table name as a parameter. I am trying to use that parameter in another PQ to specify the source to use.

My parameter is pd_tbl_Project_Common_Parameters and it equals table_ProjectParameters. (see picture below)

Capture.PNG

I am then trying to use this in the following source description:

Please Login or Register  to view this content.
What I want is to use the parameter instead of hard coding the table name:

Please Login or Register  to view this content.
I get the following error:

Capture.PNG

I don't understand enough of power query to interpret the error I am getting. Additionally from other things I have read and videos I have watched it seems that in concept this should be possible.