PowerQuery reference cell value

[Imbizile]

Hello

How do I reference a cell value and use that value in PowerQuery?

Example, lets say I have a workbook in C:\ExcelFiles\ that is used as a source in PowerQuery, like this:
pq1.png


I have that value "C:\ExcelFiles\" in a cell, in this case in E2:
sourcefolder.png

I would like to change the blue text in the first screenshot, ie "C:\ExcelFiles\" to use the value in E5 instead.

How can this be accomplished?

[AliGW]

You'll need to create a parameter from the cell with the source data. Have a look here: https://community.powerbi.com/t5/Des...er/td-p/395121

[Imbizile]

Thanks for the answer AliGW

I could not get it to work with the Parameter solution you posted, and I also found some other solutions on the net, that supposedly should do the same, but all of them failed.

Until I stumbled upon this post, where the reason for all the fails is mentioned: https://accessanalytic.com.au/powerq...ls_parameters/
It says: For this to work you will need to change your privacy settings to “Ignore”, via Query Options > Privacy > Always ignore Privacy Level settings

After I changed that setting, it works (though not sure what security risks that now involves)

Anyhow, thanks again

[AliGW]

Good to know - thanks for letting us know.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.