topic Re: Microsoft Power BI Output Tool - Error Message for authentication in Alteryx Server Discussions

Microsoft Power BI Output Tool - Error Message for authentication

alexi2019 — Wed, 11 Mar 2020 00:02:29 GMT

Hi all,

I want to run an Alteryx Workflow in the Gallery. The workflows ends in writing Power BI data direct into Power BI. It works on the local machine and does not work in the Gallery. When running the workflow, it throws me these errors:

The job New Workflow7 did not complete successfully and resulted in the following errors:

Failed to decrypt value for clientSecret! (Tool Id: 2)
Failed to decrypt value for password! (Tool Id: 2)
Please enter a client secret (Tool Id: 2)
Failed to decrypt value for accessToken! (Tool Id: 2)
Please log in (Tool Id: 2)

While I understand, that it has something to do with the Authetification, I do not know how to bring all keys and passwort into the Gallery. Had anyone else this experience?

Thanks

Re: Microsoft Power BI Output Tool - Error Message for authentication

MattH — Mon, 16 Mar 2020 16:17:36 GMT

Hi @alexi2019

This is a known issue with the Publish to Power BI connector. Our development team is aware and working to resolve the connection issue. There currently is not a workaround.

Re: Microsoft Power BI Output Tool - Error Message for authentication

Patrick_N — Mon, 27 Apr 2020 18:54:38 GMT

Matt,

I'm seeing similar errors here working with the OneDrive input/output tool publishing to Alteryx Server. When I run the flow locally, it runs fine, however when I publish to server I'm seeing:

[filename] Tool 9 - Failed to decrypt value for od_ClientSecret!

[filename] Tool 9 - Please enter a Client secret

[filename] Tool 9 - Failed to decrypt value for od_AuthToken!

[filename] Tool 9 - Please log in

Is this PowerBi Connector issue the same bug as the integration with your OneDrive input/output tool? If so, any idea when this bug will be patched or a workaround provided?

Re: Microsoft Power BI Output Tool - Error Message for authentication

veruzi — Tue, 23 Jun 2020 05:38:55 GMT

I have the same issue with OneDrive - did you manage to make it work?

Re: Microsoft Power BI Output Tool - Error Message for authentication

Patrick_N — Wed, 24 Jun 2020 15:18:52 GMT

Veruzi,

The good news is yes, we were able to get to a workable solution to resolve this problem. We created a ticket through Alteryx support (e-mail support@alteryx.com) and they reconfigured some settings on our Alteryx server instance as well as my local machine.

Definitely recommend you starting a ticket through their support team and reference this thread so they can walk you through the server reconfig steps. Also, feel free to reach back out to me if the support rep you're working with needs additional context or direction from our rep.

Re: Microsoft Power BI Output Tool - Error Message for authentication

veruzi — Wed, 24 Jun 2020 15:56:44 GMT

Thank you Patrik!

I've already opened a ticket with the Support team and we'll be meeting tomorrow to apply the workaround 🙂

Re: Microsoft Power BI Output Tool - Error Message for authentication

jsandona — Mon, 15 Mar 2021 02:16:54 GMT

Hi @MattH and @alexi2019 , I'm running into the same errors when I try uploading/using the PowerBI Output connector on our private gallery. Has there been any resolution for this issue?

Thank you!

My error messages are:

Failed to decrypt value for clientSecret! (Tool Id: 91)
Failed to decrypt value for password! (Tool Id: 91)
Please enter a client secret (Tool Id: 91)
Failed to decrypt value for accessToken! (Tool Id: 91)
Please log in (Tool Id: 91)