Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am conducting Direct Query SQL Server Database Connection, and receive this message when filtering "Unable to obtain the list of items." This table has 1 million customer ids. I understand it is large for Direct Query, however, would like to at least see the top 1000 rows on filter preview. We are utilizing columnstore indexes
(1)
I want to utilize Basic Filter, and Not do a specific search. Is there anyway to change memory settings or row limit fitler settings in Power BI?
(2) Additionally, with SSAS when connecting to cube with 1million customers, it would show the first 1000 or so. How do I get it to be like SSAS?
I have precisly the same issue except i just want the basic filter to work on countries
I only have about 4956 records to filter on not millions
Any solutions?
well I want All the data, only just the first few 100 rows on the filters, so it does not time out, I am aware of the data query options,
are you saying if I have an aggregation of more than 5 million rows, this will work?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |