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.
Hi I I have a direct query with SQL sitting on AWS cloud. The connection to the cloud is quick (so no issue there). Using performance analyzer I am expereincing 65secs visual refresh and I am aiming to get to 15secs. I have zero Calculated Columns and probably 15 calculated Measures. In this 400M row of data consist of data for Year 2019 and Year 2020 down to 10minutes interval. Can you offer any other option for me to improve perfromance from 65 secs to 15secs The DAX measures that takes the longest refresh is = Calculate(Sum(Table[datacolumn]), Filter(Table,[year]="2020") / Calculate(Sum(Table[datacolumn]), Filter(Table,[year]="2019")...thank u
Solved! Go to Solution.
@Anonymous , refer if composite model can help in this case
@Anonymous , refer if composite model can help in this case
wow.. this is it!
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |