Power BI

Needs Votes

Create parameter in SSAS live connection model

Vote (94)

Sreekanth on 02 Jun 2017 21:55:51

When I use SSAS(live data) as source, I'm seeing most of the parameter functionality is grayed out. I think it would be good if I can create and configure report parameters in power BI on-premise same way as SSRS.
Since, slicing is very much required functionality for any reports, I think this enhancement is needed one.

Comments (12)

Ankur Verma on 26 Jun 2023 21:42:38

RE: Create parameter in SSAS live connection model

one way I was able to achieve this by writing a program to extract pbix files, change JSON in Connections file, then add it back into zip (named .pbix). since I have a bunch of reports this program speeds up things as compared to changing 1 report at a time thru Power Bi desktop.

Ian Stuart on 09 Feb 2023 14:19:37

RE: Create parameter in SSAS live connection model

Definitely need this when promoting live connection reports through DEV, TEST and PRODUCTION

on 18 Apr 2022 20:24:04

RE: Create parameter in SSAS live connection model

Would be awesome to change parameters in reports if they were connected to Power BI Database

on 18 Apr 2022 20:23:42

RE: Create parameter in SSAS live connection model

We need the ability to create an template Power BI report with Parameters for Azure Analysis Services Live connection datasource. Without this we cannot make publish our solution to AppSource or reuse template for other projects.

You can do parameters and templates for SQL Server DirectQuery datasources so why not for Analysis Services?

Davi Pistorello on 27 Oct 2020 12:52:17

RE: Create parameter in SSAS live connection model

https://ideas.powerbi.com/ideas/idea/?ideaid=d427a8d1-f616-eb11-8441-501ac524afb0

Scott Thornburg on 06 Jul 2020 00:18:09

RE: Create parameter in SSAS live connection model

May be a different idea, but I would like this extended to any Power BI service dataset live connection. Like others have noted below, that allows me to publish reports and easily configure them to point to DEV, Test, and Prod live connected datasources.

Nick Bright on 05 Jul 2020 23:40:52

RE: Create parameter in SSAS live connection model

Parameter functionality is fundamental to any good report so if priority could be given to this aspect while using SSAS (AAS in my case) this would be a leap forward.

N