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 guys,
I have a very big cube that has data from all over the world, but I only need one specific country.
I could import everything and then filter it, but since its too big, I keep getting and error message whenever it passes 10 million rows loaded, saying it ran out of query time.
Is there a way to filter before importing?
What is the cause of this error? Memory? Network? Capacity?
Ps.: I can't use live data because I already have other sources in this Power BI file, so only Import option is enabled.
Thanks!
Solved! Go to Solution.
Use "Advanced options" when creating your query and paste in your MDX to filter the data at the time of query.
Use "Advanced options" when creating your query and paste in your MDX to filter the data at the time of query.
It worked! Thanks
What's the MDX code to filter 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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |