Forum Discussion
query only top n from sql server by a column within specified date range
I have a large set of data that exceeds power bi row limits and am getting operation timeout. I want to query only top n rows from sql server based on one column and also want to have date filter on ...
Hi Anonymous ,
You could reference the similar threads to have a try.
https://community.powerbi.com/t5/Desktop/Power-BI-parameter-for-SQL-Query/m-p/1083092#M501538
https://community.powerbi.com/t5/Desktop/How-to-use-parameters-in-Power-BI/td-p/651552
Hi v-xuding-msft ,
I don't want use the query parameters as they won't be available in the power bi online service.
can you suggest any other methods !!
Thanks