DifferentSource - HELP!

[aroldan]

Hi everyone,

Im trying to connect a data source with a parameter but no how Power BI offers.

The thing is that I have two kind of client, the one who use Hana connection and the other that use SQL.

What Im trying to do is something like this:

-Create Source Parameters for each one

    SQLSource = Sql.Database("server","bd")

    HANASource = SapHana.Database("serverhana")

-One parameter to point one of them

    ConnectionSource = SQLSource

    or

    ConnectionSource = HANASource

-Finally get this

    Source = ConnectionSource

Why I'm trying to do this? because I want to avoid to have two reports/forms one for each kind of client.

There's any way to make it?

Thanks for your time

[Anonymous · Accepted solution]

Hi @aroldan,

Perhaps you can try to use below conditional query if it suitable for your requirement.

Comment: When ServerName and databaseName are null, use sql connector; if databaseName is null, use hana connector, otherwise return null.

let
    SQLOrHana= (ServerName as text, databaseName) =>
    let
        Source= if ServerName <> null and databaseName <> null 
                then Sql.Database(ServerName,databaseName) else 
                if databaseName = null and ServerName <> null then SapHana.Database("serverhana") 
                else null
    in
        Source
in
    SQLOrHana

Regards,

Xiaoxin Sheng

[aroldan]

Thank you so much, that was so helpfull