Forum Discussion

trt18-sistemas's avatar
trt18-sistemas
Icon for Advocate IV rankAdvocate IV
4 years ago
Solved

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?

 

  • trt18-sistemas's avatar
    trt18-sistemas
    4 years ago

    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

  • Please verify that you are the owner of the dataset in Test stage.

    Onlt dataset owners can configure rules.

    • trt18-sistemas's avatar
      trt18-sistemas
      Icon for Advocate IV rankAdvocate 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's avatar
      trt18-sistemas
      Icon for Advocate IV rankAdvocate 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's avatar
        Nimrod_Shalit
        Icon for Power BI Team rankPower 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?