Forum Discussion
SQL query with user defined parameters (slicer, filter, input value) - Big Data
Hi guys, I have an SQL table with ~2TB of time series sensor data, and couple billions of rows, and I want to visualize parts of the table in Power BI. The table itself is fast - considering ...
Hi Anonymous
I'm not sure if I understand your need, but I don't think dynamic queries are an option. It kind of defeats the point of Power BI. My thought is you should import the entire SQL table using import method, set up a scheduled refresh when no will be using the report, and then set up a slicer or multiple reports/dashboards to suit the various end user needs. This is what Power BI is intended for.