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 there,
I have a large dataset report with around 9 GB raw data retrieving from SQL database based on defined query parameters. I have no issue to change the query parameters (which are time ranges) and refresh the report.
However, after adding serveral calculated columns, tables and measures to the report (some of them involves entensive calculations and depending on each other), when I change the queqry parameters and do the refresh, it takes forever to finish. I think it was due to that dependencies of "added calculated columns, tables and measures" on each other. I just wonder if there is a way to manually define the execuation order of "added calcuated columns, tables and measures" or disable them first when doing the query fresh.
Thanks,
Ty
Solved! Go to Solution.
There is no way to manually define execution order or omit something like calculated columns during a refresh.
There is no way to manually define execution order or omit something like calculated columns during a refresh.
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 |
---|---|
112 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |