Connecting Excel to Power BI Dataset with parameters

[OxfordPowerBI]

Hi there,

I'm trying to connect to a Power BI dataset from Excel and to pass a parameter from a cell or rangename. When I go to the connection settings, the parameter box is greyed out. Is there a way to get around this?

Alternatively, in the DAX code in the Command text box, it currently begins with something like

DEFINE
	VAR __DS0FilterTable = 
		FILTER(KEEPFILTERS(VALUES('Data'[OrgID])), 'Data'[OrgID] = 303)
etc....

I would like to replace 303 with a range name or cell reference. 

Thanks!

[#2 · Accepted solution]

@OxfordPowerBI 

To my knowledge Parameters is not available for OLE DB query connection.

[#3]

Thanks!