Forum Discussion
Query parameters greyed out in Power BI Service
- 3 years ago
The issue was that the parameters was set to type: "Any". Switching them to "Text" fixed the issue.
- 2 years ago
From the documentation:
"Grayed-out fields aren't editable. Any and Binary type parameters work in Power BI Desktop. The Power BI service doesn't currently support them for security reasons."
https://learn.microsoft.com/en-us/power-bi/connect-data/service-parameters
The issue was that the parameters was set to type: "Any". Switching them to "Text" fixed the issue.
Thanks. This helped fix my issue too. Connecting to Databricks data source, so according to this, Databricks is not supported for Data source rules to switch the Schema names etc, so had to use parameters. The Parameter rules are not greyed out now after changing the parameter type from "Any" to "Text".
Create deployment rules for Fabric's ALM - Microsoft Fabric | Microsoft Learn