PowerApps中PowerBI连接器ExecuteDatasetQuery返回空表问题
PowerApps中PowerBI数据连接器ExecuteDatasetQuery返回空表问题
- 问题与PowerBI磁贴或PowerApps嵌入可视化无关,针对PowerBI数据连接器的ExecuteDatasetQuery方法
- 该方法需传入三个必填参数:
workspaceGuid、datasetGuid、queryText,另有可选序列化设置对象 - 异常现象:无论传入何种DAX查询(甚至简单的
EVALUATE(MyTable)),返回结果都是行数与预期一致,但无列无值的空表;将结果转为JSON字符串后,确认内容完全为空 - 对比验证:相同的DAX查询在JavaScript API调用、PowerAutomate、PowerBI Desktop中均能正常返回数据
- 当前困境:找不到该连接器及方法的有效官方文档,寻求有相关经验的用户提供解决方向
参考DAX查询示例:
DEFINE VAR _reqs = SELECTCOLUMNS(MyTable, "ReqNum",[Title], "BusinessArea",[BusinessArea], "Serial1",[Serial1], "Serial2",[Serial2], "Department",[Department], "OM",[OM], "Requestor",[Requestor], "StrategicObjective",[ITStrategicObjective], "Area",[Area], "ProductLine",[ProductLine], "ProjectManager",[ProjectManager], "BusinessLiaison",[BusinessLiaison], "Customer",[Customer], "SolutionArchitect",[SolutionArchitect], "VicePresident",[VicePresident], "Created",DATEVALUE([Created]) ) EVALUATE _reqs ORDER BY [Created] DESC
内容的提问来源于stack exchange,提问作者ChrisPEditor
相关产品推荐
相关产品推荐

