Forum Discussion

aroldan's avatar
aroldan
Frequent Visitor
9 years ago
Solved

DifferentSource - HELP!

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....
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
    aroldan
    Frequent Visitor
    9 years ago

    Thank you so much, that was so helpfull:smileyvery-happy: