Skip to main content

Power BI

New

Create parameter in SSAS live connection model

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

5623eee5 530a-4f1f-930e-df858e703aac 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

a238d472 4382-4083-82d0-fb125643ea9a 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

fdd6c11b e8db-45fa-8fca-2553bb19b3e5 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

8cab463c 08d4-418c-85c2-49adfab666f9 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

d4d394cf 6d8f-4430-a8f6-98edf1646dde on 05 Jul 2020 23:29:07

RE: Create parameter in SSAS live connection model

please add connections for live model.

Sreekanth's profile image Profile Picture

fe56ae6b e714-404a-bbb6-bfa28f938fe3 on 05 Jul 2020 23:26:15

RE: Create parameter in SSAS live connection model

I have an urgent need. Please add parameters for SSAS tabular live connections.

Sreekanth's profile image Profile Picture

987e92c5 31f4-47d9-b2b5-9b4fd9d97a96 on 05 Jul 2020 22:55:33

RE: Create parameter in SSAS live connection model

Agree, query parameters are required for SSAS Live connections.