Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Mates,
I am building dashboard using synapse as a datasource. our table is pretty huge so I have created the materialized view in synapse . i.e my aggregation stores in memory. If i write a select it will fetch from memory rather than the original table.
if i create aggregation in powerbi, i can confirm powerbi hits the aggregation using dax studio sqlserver profiler.
likewise how can i confirm that my powerbi hits the materialized view in synapse to pull out the result ?
Your help is much appreciated!
For more details,please refer to:
https://docs.microsoft.com/en-us/azure/synapse-analytics/get-started-visualize-power-bi
Hi @V-lianl-msft - This is not the one i am looking for. Please read out my description for my problem
User | Count |
---|---|
13 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
3 | |
2 | |
2 |