filtering data from HANA source

[ramkula123]

Hi All ,

I need to pull data from HANA view into Power BI based on a column 'FName' .

ex :  select ..... from ...

where FName is in ('abc',efg' ,xyz)

Since the requirement does not want the values to be hardcoded  in the WHERE clause in the select statement , I m looking for a dynamic way of passing values to the WHERE clause in the select statement so that only relevent data gets pulled from the HANA to PBI .

Is it possible to achieve this ? and how can the paramenters be passed to the where clause ?

Thank you

[v-xicai]

Hi @ramkula123 ,

Your demand is a good idea, while it is not supported to implement in Power BI currently. You can post your new idea here https://ideas.powerbi.com/forums/265200-power-bi-ideas , to improve the Power BI.

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[ramkula123]

Hi @v-xicai Amy ,

Thanks for inputs . In such case any idea what would be the best way to handle large / growing  data ? The idea here is to filter the data at the source, insteading of importing full data and would not need developer's intefrence ( give flexibility to users to make the choice) 

Thanks