Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Parameters Not Showing up in Service

Hi All,

I have a Power BI report connected to an Azure SQL Database through a direct query connection.
I have created 2 parameters in it : ServerName & Database , so that I can repoint the report and deploy to different environments easily.
But The Problem is that it is not showing up in the service :

Thanks.

Need Help

5 Replies

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    I didn't reproduce your problem, are you sure that the parameters are correctly created in your report?

     

    "Parameters haven't been defined for this dataset yet. If you want to set parameters, use the Query Editor."

    This error means that your report contains no parameters, So check the parameters in the file again by using the PBI desktop.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi v-lionel-msft ,

      This is the Advanced Editor for a table used in the Report (ServerName & DBName are the Parameters) :

      • v-lionel-msft's avatar
        v-lionel-msft
        Community Support
        6 years ago

        Hi Anonymous ,

         

        Try to change the value of ‘CreateNavigationProperties’ option to true.

         

        Best regards,
        Lionel Chen

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

         

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi v-lionel-msft ,

      I tried the same file in import mode and I could see the Parameters in Service. Why is this not working in direct query?