Parameters and Templates in Power BI Desktop

[lync0056]

Hi All,

Need some help with Parameters in Power BI Desktop. Parameters works perfectly for me with the server and database, but I need the schema as well, please help.

How do I do a parameter on the schema? It doesn't work when I put the parameter inside the schema.

let
Source = Sql.Database(Server, Database),
dbo__addresses = Source{[Schema="dbo",Item="parameterTest"]}[Data]

Server and Database working great. ParameterTest no good.

[freder1ck]

should parameterTest be in quotes?

[lync0056]

Neither with or without quotes works.

[MarcelBeug]

My suggestion would be to share all relevant information required to help you.

Any screen shots of the relevant table entries at the source step, the value and definition of you parameter, anything else that might be relevant.

I will illustrate below.

In my opinion it should work without the quotes.

This works with me (but I don't have a sql database).

let
    Source = #table(type table[Schema = text, Item = text, Data = text],{{"dbo","Item1","Data1"},{"dbo","Item2","Data2"}}),
    dbo__addresses = Source{[Schema="dbo",Item=parameterTest]}[Data]
in
    dbo__addresses

Table at the Source step:

Query Item (for the list with valid parameter values):

let
    Source = #table(type table[Schema = text, Item = text],{{"dbo","Item1"},{"dbo","Item2"}}),
    Item1 = Source[Item]
in
    Item1

parameterTest:

[lync0056]

[freder1ck]

lync0056, 

Ah, your parameter is named Username? That might be a reserved keyword. And, yes, parameters should not be in quotes. 

Fred

[lync0056]

Tried ClientUsername and same error

[MarcelBeug · Accepted solution]

In your parameter you refer to query Accounts and in your previous post I see a query Accounts in which the parameter is used.

That is most probably causing the cyclic reference error.

The query referenced in your parameter should be a query that just creates a list of valid entries you can choose from, not the query in which the parameter is used.

[lync0056]

All working now, thank you very much.