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
I'm building a solution that is going to use Power BI and Azure Analysis Services Live Connection for multiple customers.
Is it possible to use parameters for the Azure Analysis Services Server Connection?
Hi @baatch,
It is impossible to pass parameter at live connection mode.
If you mean pass user name to filter on datasource, I'd like to suggest you use RLS with AS datasource.
Reference link:
Tutorial: Dynamic row level security with Analysis services tabular model
Regards,
Xiaoxin Sheng
@v-shex-msft thanks for replying.
Would it be possible to build a custom data connector for a live connection to then pass parameter for the server name?
HI @baatch,
Nope, power bi not support this and I also not think this text (server name with parameters) can works as normal server name.
Regards,
Xiaoxin Sheng
Hi
I'm building a solution that is going to use Power BI and Azure Analysis Services Live Connection for multiple customers.
Is it possible to use parameters for the Azure Analysis Services Server Connection?
Hi
I'm building a solution that is going to use Power BI and Azure Analysis Services Live Connection for multiple customers.
Is it possible to use parameters for the Azure Analysis Services Server Connection?
@baatch, see parameters here: https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
Is this what you are referring to as far as parameters?
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 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |