Forum Discussion
Solved
Query parameters greyed out in Power BI Service
Hello Community, I am using query parameters in Power Query to be able to change what Google Big Query project/dataset I am fetching data from. This works great in desktop but when I publish to th...
The issue was that the parameters was set to type: "Any". Switching them to "Text" fixed the issue.
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
BIanon , I am hoping you are talking about datasource setting in the power bi service. This means data source credential has some issue or you are also using local source that need gateway
No I am talking about the section beneath data source setting called "Parameters".
Why do you hope I am talking about datasource settings?