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!
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! Read More