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 everyone,
Understood there are many limitation in Direct Query. And also I find it impossible but I guess I encourage my self to post this question ->
How can we achieve SUMMARIZE without the loose of full Direct Query mode ? is there a workaround ?
Thanks,
Solved! Go to Solution.
@admin_xlsior , Please refer to the composite model can help
@admin_xlsior , Please refer to the composite model can help
Hi @amitchandak
Thank you very much. Just what I need, never knew it before.
I want to use it to create some lookup table (master table) from my FactTable. Just now in Power Query, I put the reference and use Group by, and it works and even the "aggregated table" still consider as a "Direct Query"
Many thanks,
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |