'Filters on power query don't scale on cubes
I'm trying to import data from a SSAS Cube using PowerQuery. My problem is that when I try to filter it by year column and import it, it always gets the whole cube... In my need is like 30-40k rows from this year but it always try to get 2 milions rows and going on ~~400 rows/sec it takes quite long and ends with a timeout. Any advice on how to do it?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|