Remove 1,000,000 row maximum on result set in Using DirectQuery for Power BI datasets and Azure Analysis Services (preview)

Direct query has a 1,000,000 row limit on result set of a query to external data. Can that limit be removed?

power bi

nishalit

New Member

4 years ago

This capability is now in Public Preview. Changes to AS server properties in PBI are now available.

Recent ideas

Adjustable Tooltip Size
I have a tooltip in one of my dashboards that displays a table when you hover over the original visual. Some of the tables have 8 or so rows, but some of them only have 1 or 2. When the tables with ...
abetts
New Member
13 hours ago
New
Views
10likes
Comments
extend storage capacity of varchar(8000) to varchar(max) for warehouse
The maximum string length of 8000 is often considered too short to store longer descriptive data or embed a JSON value within a text field in a database. Dividing the data into smaller chunks and st...
c_mettler
New Member
2 days ago
Completed
Views
61likes
Comments
Adjust column width in SQL Analytics Endpoint user interface
I can't see the column names and cell values in some of the columns in my tables in SQL Analytics Endpoint because the column width is too narrow. Also, the tooltip also doesn't show the entire...
frithjof_v
Community Champion
2 days ago
Completed
Views
75likes
Comments
In TableEX visual when using Custom tooltip, it shows below it the automatic "-> Drillthrough >"
Using in the Power Bi's Service Cloud. In TableEX visual when using Custom tooltip, it shows below it the automatic "-> Drillthrough >" and selects & clicks the drillthrough page. In TableEX vis...
LR3
Regular Visitor
2 days ago
New
Views
0likes
Comments
Allow Power BI subscription sender identity to be configured
The new Power BI subscription delivery platform changed existing subscriptions so that notification emails now show the subscription owner as the sender instead of mailto:[email protected]...
bbussey
Regular Visitor
2 days ago
New
Views
5likes
Comments

Remove 1,000,000 row maximum on result set in Using DirectQuery for Power BI datasets and Azure Analysis Services (preview)

Adjustable Tooltip Size

extend storage capacity of varchar(8000) to varchar(max) for warehouse

Adjust column width in SQL Analytics Endpoint user interface

In TableEX visual when using Custom tooltip, it shows below it the automatic "-> Drillthrough >"

Allow Power BI subscription sender identity to be configured