Forum Discussion
Filter before querying. Performance issues showing data in table visualization
Hi, I have a table with 4 million rows in sql server connected via direct query, and I'm trying to show the records in a table visualization, but that brings performance issues, even with filters...
Hi Anonymous ,
It seems that use Query Parameter should achieve your requirement.
Is it possible to do something similar? To avoid bringing the whole table. Query parameters wouldn't work because they aren't available to the consumer of the report in Power BI Service
By my tests, if you set the workspace with edit permission and when the consumer Take over the dataset then they could modify the parameter.
Best Regards,
Cherry