Forum Discussion
Post PatronHow To Filter Data Before loading with Direct Query option using Redshift
Sorry for the delay in responding.
You can use parameters in Power BI to filter the data as shown in the attachment. If that approach doesn’t work, an alternative workaround would be to create a dedicated reporting table in Redshift and use it as the source for your view. Then use view as a source in Power BI model in Direct Query mode. You can populate this reporting table by writing a stored procedure that refreshes the data daily (or as per your requirements) and schedule it accordingly. Since the model is connected in Direct Query mode, the report will always reflect whatever data is available in the reporting table, and you can still apply additional filtering within Power BI using page level slicers.
Thanks.
Post PatronHi lbendlin,
Thanks for your response.
I am connecting through Direct Query Mode as my data in views are huge.
My views are having only required columns. I am not able to get the Query folding. I am struck with the approach to dynamically filter (On the fly based on my report slicers, query need to redshift and fectch the required data to improve my report performance.)
Please suggest the better approach. if you can share the M code with one or two dynamic filter columns, it will be helpful for me.
Thanks,
Sri
Super User I am not able to get the Query folding.That's a showstopper. Can you elaborate why you are not getting folding?
- Koritala
As Far as I know Redshift database doesn't support Query Folding or Incremental Refresh functionality. correct me if I am wrong.
Thanks,
Sri
- Koritala
Hi lbendlin,
I have gone through your url but none of the place not talked about query folding. Apart from that, we followed the same approach in our semantic model and service.