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:
What I want is to use the parameter instead of hard coding the table name:
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.
Bookmarks