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
I am facing the same issue for a parameter of type "Any". Can also confirm that parameters of type "Text" work fine and are not grayed out for this same data set I have - they work and are not grayed out.
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