Help connecting to Direct Query from existing PBI visual

[swathigaru]

Hi,

I am trying to build a view which gets data from a table in ADW which has around 80 M rows. I have added this table to the existing PBI Design , so that i want to retrieve the results from the new table only based on selection.

Even while building the visual i get the error " Could not load due to maximum limit of 10000000 rows" .How can i build a view first without the query executing at the back end?

I tried to change my direct query to TOP N rows which is set to 500 and built the visual. But when i am filtering the data from any other visual i am not getting the required results though the data is available at the back end.

This is the flow i wanted

Flow - 

Existing Import model table ( which has around 15M rows)=> linked to Direct Query table ( which has around 80M rows)

When user chooses any slicers/filters the data , i need to fetch only the required records based on the condition.

Can you please suggest me how can i build this?

Thanks in Advance

[v-yulgu-msft]

Hi @swathigaru,

Unfortunately, such a requirement is not supported by Power BI right now.

Regards,

Yuliana Gu

[Anonymous]

Any update on this feature request?  This is also a blocker for me.  I use aggregated data to find anomalies, and then I want to display atomic elements that are part of the anomaly from a multi billion rows RedShift table.