Skip to main content

Power BI

Needs Votes

Create parameter in SSAS live connection model

Vote (94) Share
Sreekanth's profile image

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)
Sreekanth's profile image Profile Picture

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.

Sreekanth's profile image Profile Picture

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

Sreekanth's profile image Profile Picture

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

Sreekanth's profile image Profile Picture

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?

Sreekanth's profile image Profile Picture

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

Sreekanth's profile image Profile Picture

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.

Sreekanth's profile image Profile Picture

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

Sreekanth's profile image Profile Picture

Salvatore Cagliari on 05 Jul 2020 23:39:08

RE: Create parameter in SSAS live connection model

This would be extremely convenient, to switch between DEV/Test & Production environment directly on the report.

Sreekanth's profile image Profile Picture

vick on 05 Jul 2020 23:30:37

RE: Create parameter in SSAS live connection model

i need query parameter in SSAS Live connection please, still grayed out

Sreekanth's profile image Profile Picture

bhuvan on 05 Jul 2020 23:29:07

RE: Create parameter in SSAS live connection model

please add connections for live model.

Merged Idea (2)