Forum Discussion
Dataset parameters disabled (greyed) at Pipeline
Hi there,
I'm facing a similar problem to the one reported here (https://community.powerbi.com/t5/Service/Deployment-pipelines-Parameters-Invalid-Rule/m-p/1175862).
I have Premium per User licence and I'm trying to use parameters at pipeline, but it's not working. I've created a very simple dataset that loads a manual created table and it has a parameter that is not actually used.
Below is the code to create the table:
let
Fonte = #table({"col1", "col2"}, {{"val1", 1}, {"val2", 2}, {"val3", 3}})
in
Fonte
And now the parameter configuration window:
When I upload this report to dev workspace it runs ok, but when I try to edit the Parameter at test workspace it's not enabled.
That's the pipeline screen showing that all datasets and reports and synchronized:
But, when I try to set the parameter at Test workspace it's disabled:
On the Message I refered above (https://community.powerbi.com/t5/Service/Deployment-pipelines-Parameters-Invalid-Rule/m-p/1175862), the solution is to set parameters and access at dataset on its workspace. I did it, but it's disabled anyway.
Any clue?
Posting the solution.
On my example, the parameter data type is set as "any" (qualquer in portuguese). By setting as "text" it worked.
As simple as that .... rsssss
11 Replies
- Nimrod_Shalit
Power BI Team
Please verify that you are the owner of the dataset in Test stage.
Onlt dataset owners can configure rules.
- trt18-sistemas
Advocate IV
Hi Nimrod_Shalit,
I forgeted to mention that part. I'm the owner as I created the workspace. My profile has administrator access to the workspace, check it at image below.
- trt18-sistemas
Advocate IV
Actually, I didn't check it on the right place. My access right to the dataset at Test Workspace is as Administrator/Owner ("Proprietário" in Portuguese):
- Nimrod_Shalit
Power BI Team
additional option is that the dataset is only connected to Power Bi artifacts, such as dataflows, and not to external data sources. Can you specify which data sources are this dataset connected to?