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 All,
I am having trouble with Power BI, Filtering data in Power Query is still loading all data into model, I tried filtering on a single row and filtering using parameter/s both resulted in the same result which is : Power Bi is loading all data no matter the filter .
* On the right- NotePad is countdistinct of rows (in Power query after filtering that need to be loaded) And on the left Power BI loading 79K rows !
How is this possible ? is it a bug ? I remember one time the filter did work and it loaded only filtered data, but now it isn't
anyone having this issue ?
Thanks in advance
@amitchandak Hi,
The database says the same number of rows as the power query. still Power Bi is loading the whole table .
Am I mising something ? By the way this doesn't happen when filter Top 30 rows for example - in this case normally Power BI loads only those rows to the model .
I also tried filtering to 1 Row in power query and still power bi is bringing the whole table .
what do you mean by Data view ? you mean in Power BI yes? It will take forever until I can access that tab ...
I am waiting for power Bi to load the whole 75K row table.. it's showing "loading 2,500 Rows from fact..."
@Shabb , a good way to check is to check the query folding - https://docs.microsoft.com/en-us/power-query/power-query-folding#determine-when-a-query-can-be-folde...
if query folded property, it should not load data to power bi
I am running on Oracle database ,sorry I don't understand why query folding is a problem in my case .
@Shabb , Do not check this count. Go to data view and check rows in table.
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 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |