Skip to main content
Microsoft Idea

Power BI

New

Field Parameters in live connection data sources

Vote (43) Share
Nazeerul Hazard's profile image

Nazeerul Hazard on 19 May 2022 15:58:07

Allow creating field parameters in live connection data sources

Comments (4)
Nazeerul Hazard's profile image Profile Picture

Niels Duijndam on 10 Apr 2024 10:40:49

RE: Field Parameters in live connection data sources

I'm so surprised this does not have many more upvotes.This is a very powerful feature in Power BI and it can even be used to properly implement OLS alongside RLS without errors. However, because it's not supported in Live reports, it's hardly worth the effort, since any serious developer will need want to reuse models, rather than repeat the refreshload for semantic models.Obviously, besides the OLS / RLS application, this is a very useful feature in any report.Please implement this!

Nazeerul Hazard's profile image Profile Picture

Amy Spracklen on 29 Nov 2023 23:04:02

RE: Field Parameters in live connection data sources

Important to note that the field parameters created in a dataset are not usable in a live connected report. So if I add one, the option to show field values is not there...this is really needed. Hope this gets added soon!!!

Nazeerul Hazard's profile image Profile Picture

Joyce-X Wang on 23 Mar 2023 07:16:51

RE: Field Parameters in live connection data sources

The field parameter is really useful for views to dynamically select the columns or measures in the table. Similar workarounds for parameter like unpivot tables or create DAX data table aren't supported in live connection as well. Please consider adding that feature which would really help a lot.

Nazeerul Hazard's profile image Profile Picture

Bartosz Gestwa on 27 Jul 2022 06:46:54

RE: Field Parameters in live connection data sources

Exactly. Local measures are a thing in 'Thin reports' and it's super useful. Local field parameters without creating a dataset would be a huge deal for 'Golden dataset' environments.