Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello!
Where can I find the filter for REPORT LEVEL?
Everytime I refresh, my model queries the data for 5 years of Salesforce and it's driving me crazy.
The filter pane only shows THIS PAGE and ALL PAGES.
Thank you!
Solved! Go to Solution.
All Pages is Report Level. THere are three filters:
EDIT: I see you are talking about refreshes.
All DAX Filters only filter the existing data. You have to go into Power Query and filter the data as it comes in to exclude records. You need to go into Power Query and:
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingAll Pages is Report Level. THere are three filters:
EDIT: I see you are talking about refreshes.
All DAX Filters only filter the existing data. You have to go into Power Query and filter the data as it comes in to exclude records. You need to go into Power Query and:
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingTHANK YOU!!!! This works!!
Excellent @Anonymous - glad I was able to help out.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThank you.
Is there a way to limit the amount of data that is queried when I refresh?
Everytime I chnage a column header - it pulls the entire instance of salesforce. How can I prevent this?
Thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |