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!
Community SupportHi 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
Kelly
Microsoft EmployeeWe 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.