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.
Super UserDoes the data source show as Direct Query in the data model view? Are you getting error messages that your queries don't fold?
KoritalaHi 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