cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
OneWithQuestion
Post Prodigy
Post Prodigy

Parameters in service or just desktop?

Desktop has parameters you can set, but I didn't see the same feature in the web service?

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

 

 

4 REPLIES 4
v-qiuyu-msft
Community Support
Community Support

Hi @OneWithQuestion,

 

Based on my test, query parameters feature isn't available in Power BI service currently. It's only supported in Power BI desktop. If we publish the report which has query parameter values, the report display in servcie is the same as the saved results in desktop.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Any thoughts when the user can access/enter parameters themselves via the web service?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Hi @Phil_Seamark,

 

I didn't get the information when will query parameter feature available in Power BI Service. For your requirement, I would suggest you post an idea in Ideas forum.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

So, it really isn't possible to set a query parameter from the service??

Any advice on how we might be able to reduce the size of data returned from the service then? I.e. if i have a 15M row table... how can my user have one report where they can on-demand filter the data source (i.e. for data from last year vs data from current year) in order to keep the size of the data reasonable?  Otherwise we would need to load potentially terabytes of data and would very quickly exceed the allocated size limits of the PBI service...

Should we just be useing the desktop client for a production application then?

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.