Forum Discussion
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.
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 :smileyvery-happy:
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 SQLOrHanaRegards,
Xiaoxin Sheng
2 Replies
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 SQLOrHanaRegards,
Xiaoxin Sheng
Thank you so much, that was so helpfull:smileyvery-happy:
