"Send to Power BI" is returning "Execute failed: Unknown reason" exception

Hi,

I’m getting an “Execute failed: Unknown reason” exception when running “Send to Power BI” node, connected to PowerBI through an “Client/Application secret authentication”. We’ve followed the note “Work with third-party apps in Power BI - Power BI | Microsoft Learn” and granted permissions according to this note.

Thank you for any advise.

Versions:
Knime Analytics Platform 4.7.1
Extension “KNIME Power BI Integration” 4.7.2.v202303231026

Exception:

ERROR    KNIME-Worker-14-Send to Power BI 3:56 Node      Execute failed: Unknown reason.
org.knime.ext.powerbi.core.rest.PowerBIRestAPIUtils$PowerBIResponseException: Unknown reason.
        at org.knime.ext.powerbi.core.rest.PowerBIRestAPIUtils.checkResponse(PowerBIRestAPIUtils.java:480)
        at org.knime.ext.powerbi.core.rest.PowerBIRestAPIUtils.get(PowerBIRestAPIUtils.java:428)
        at org.knime.ext.powerbi.core.rest.PowerBIRestAPIUtils.getDatasets(PowerBIRestAPIUtils.java:141)
        at org.knime.ext.powerbi.core.rest.PowerBIRestAPIUtils.getDatasets(PowerBIRestAPIUtils.java:155)
        at org.knime.ext.powerbi.base.nodes.send2.SendToPowerBINodeModel2.getDataset(SendToPowerBINodeModel2.java:367)
        at org.knime.ext.powerbi.base.nodes.send2.SendToPowerBINodeModel2.execute(SendToPowerBINodeModel2.java:214)
        at org.knime.core.node.NodeModel.executeModel(NodeModel.java:549)
        at org.knime.core.node.Node.invokeFullyNodeModelExecute(Node.java:1267)
        at org.knime.core.node.Node.execute(Node.java:1041)
        at org.knime.core.node.workflow.NativeNodeContainer.performExecuteNode(NativeNodeContainer.java:595)
        at org.knime.core.node.exec.LocalNodeExecutionJob.mainExecute(LocalNodeExecutionJob.java:98)
        at org.knime.core.node.workflow.NodeExecutionJob.internalRun(NodeExecutionJob.java:201)
        at org.knime.core.node.workflow.NodeExecutionJob.run(NodeExecutionJob.java:117)
        at org.knime.core.util.ThreadUtils$RunnableWithContextImpl.runWithContext(ThreadUtils.java:367)
        at org.knime.core.util.ThreadUtils$RunnableWithContext.run(ThreadUtils.java:221)
        at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
        at org.knime.core.util.ThreadPool$MyFuture.run(ThreadPool.java:123)
        at org.knime.core.util.ThreadPool$Worker.run(ThreadPool.java:246)

Workflow:

It was not possible to identify the root cause.

After some tries, we changed the authentication mode to user/pass and the connection worked fine.

Thank you.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.