Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
When using direct query mode , it is failing with 1 million limit ,Can we use dynamic filtering of data so that based on the filter selected only if it will refresh the backend table reffered. Actual back-end table will contain the entire record and based on the power filter ,power BI will fetch only the required data which is lessthan 1 Million. Other alternatives are also welcome
You can use parameters to affect the rows returned by Direct Query. Take a look at this blog post. https://blog.gbrueckl.at/2019/03/using-power-bi-desktop-direct-query-with-parameters/
Help when you know. Ask when you don't!
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |