Forum Discussion

OxfordPowerBI's avatar
OxfordPowerBI
Copper Contributor
May 05, 2024
Solved

Connecting Excel to Power BI Dataset with parameters

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!

Resources