Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
Thank you so much, that was so helpfull
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |