Forum Discussion
Post ProdigyPBI WEB parameters editor
Hi Analitika ，
Sorry for the mistake.
In desktop, when you are setting the parameter,you need to set the type to text.
I set it to "any" in my last test,so you see that I cant modify the parameter in Service,once I set it to text and applied it,it becomes editable in Service,see below:
For type,see the reference:
Type—Applies a Data Type restriction to the input value for the parameter. For example, users can define a parameter of type Text, or Date/Time. If you want to provide the greatest flexibility for users, you can specify Any value from the list of available types in the drop-down.
Here is the link for the reference.
https://docs.microsoft.com/en-us/power-query/power-query-query-parameters
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
Post Prodigyparameter already setted, but not editable
Community SupportHi Analitika ，
After you have set the parameter,you need to apply it in desktop then publish to service,see below:
Go to query editor,after setting a parameter,click the dropdown button of the related column,choose text filters>equals:
Then apply parameters in "filter rows":
And in Service,you will see:
Kelly
- Analitika
Yes, but look what you cant edit it in web
- v-kelly-msft
Hi Analitika ，
Sorry for the mistake.
In desktop, when you are setting the parameter,you need to set the type to text.
I set it to "any" in my last test,so you see that I cant modify the parameter in Service,once I set it to text and applied it,it becomes editable in Service,see below:
For type,see the reference:
Type—Applies a Data Type restriction to the input value for the parameter. For example, users can define a parameter of type Text, or Date/Time. If you want to provide the greatest flexibility for users, you can specify Any value from the list of available types in the drop-down.
Here is the link for the reference.
https://docs.microsoft.com/en-us/power-query/power-query-query-parameters
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
CSAM1Microsoft Employee
We are trying to assist the customer to set up automated Power BI Deployment Pipelines, which require creating connection strings using Parameters within Power BI Desktop.
As the customer is connecting to Azure Analysis Services in DirectQuery Mode connection, they do not get an option to use Parameters for Server & DB Names—and our testing shows the same results.
Upon further research, we found an MS article, which states that Parameters have currently been disabled.
Using DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Any idea why this is disabled and if there is a way around this? This is blocking my customer tremendously.