Parameters Not Showing up in Service

[Anonymous]

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.

[v-lionel-msft]

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]

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?

[Anonymous]

Hi @v-lionel-msft ,

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

[v-lionel-msft]

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.

[v-lionel-msft]

Hi @Anonymous ,

Has your problem been solved?

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.