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.

homelander123's avatar
homelander123
Helper I
4 months ago

vigneshkumarcvk  Can you please give me a sample syntax for the fields Date, Name, Contact email, and number. 

Date and name are parameters as well

vigneshkumarcvk's avatar
vigneshkumarcvk
Resolver I
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.