Forum Discussion

homelander123's avatar
homelander123
Helper I
4 months ago
Solved

PowerBI Report builder

Hi Everyone,  I have a paginated report thats connected to a semantic model with a dataflow. I used the query designer to bring in the fields and parameters. The report has 50+ columns and 15 para...
Need Help
Show and Tell
Tips and Tricks
  • vigneshkumarcvk's avatar
    vigneshkumarcvk
    4 months ago

    Hi homelander123, Yeah sure. 
    EVALUATE FILTER(SELECTCOLUMNS('Contacts',"Date", 'Contacts'[Date], "Name", 'Contacts'[Name], "ContactEmail", 'Contacts'[Contact Email], "Number", 'Contacts'[Number]), 'Contacts'[Date] >= @StartDateParm && ''Contacts'[Date] <= @EndDateParm && 'Contacts'[Name] = @NameParm
    You can use this way to keeping the dataset lean, and applying parameters directly and ensuring performance is better than pulling all the columns.

v-echaithra's avatar
v-echaithra
Community Support
4 months ago

Hi homelander123 ,

Thank you vigneshkumarcvk  for your inputs.
We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Thank you.