Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |