在基于Azure DTU的SQL Server服务上修改msmdsrv.ini文件 [英] Amending msmdsrv.ini file on Azure DTU based SQL Server service

问题描述

任何人都可以修改SQL Server(Azure DTU)上DAX查询返回的最大行数

Anyone have any way of amending the max number of rows that are returned for DAX queries on a SQL Server (Azure DTU)

通常，您可以修改msmdsrv.ini以增加数量-但是这些服务器只能通过SQL Server Manager等进行连接.

Normally you can amend the msmdsrv.ini to increase the number - but these servers aren't connectable other than by SQL Server Manager etc.

有些PowerBI报告需要更多的作用域... ...我知道返回的数据不是100万行，因为它只是返回一个计数-但显然包括执行计数作为返回所需要的行.

Have some PowerBI reports that need more scope … I know the returned data isn't 1M rows as it is just returned a count - but it is clearly including the rows it needs to perform the count as a return.

欢呼

推荐答案

Hello,

即使使用1000万行来汇总数据，直接查询也可以返回一百万行或更少.

https://docs.microsoft.com/zh-CN/power-bi/desktop-use-directquery

Direct Query can return one million rows or less even if it uses 10 million rows to aggregate data.

https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery

希望这会有所帮助.

Hope this helps.

问候

Regards,

Alberto Morillo
SQLCoffee.com

Alberto Morillo
SQLCoffee.com

这篇关于在基于Azure DTU的SQL Server服务上修改msmdsrv.ini文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！