KNIME - POWER BI

KNIME Analytics Platform
1

Hi knime forum, I’m new on this and I need some help
I’m trying to use “Send to Power BI” node in Knime 4.1.1. but I’m having authenticate problems with my O365 account. It looks like I need special permissions.
The message I got is something like this “KNIME Analytics Platform needs permissions to access your organization’s resources and only an administrator can grant it. You must ask an administrator to grant you permissions for this app in order to use it.”
Where I need permissions? in Power BI?
Thanks

2

Hi @Jaqueri,
your organization does not seem to allow employees to grant access permissions for Power BI to external applications. Your Azure Admin needs to grant those permissions to KNIME for Send to Power BI to work. This is purely on the Power BI side.
Kind regards,
Alexander

2 Likes
3

Hi,

I do have a similar problem with the PowerBI node while Authoring.
My authentication always failed with a strange link in my browser:

http://127.0.0.1:51355/oauth?code=OAQABAAIAAAAm-06blBE1TpVMil8KPQ41Wp5z....

and the error saying: “Authentication failed. java.security.NoSuchAlgorithmException: Error constructing implementation (algorithm: Default, provider: SunJSSE, class: sun.security.ssl.SSLContextImpl$DefaultSSLContext)”

and an error message window in knime:
image

Really dont know how to reset the authentification (“Clear credentials…” etc…).

Did install the power BI node again… no Change. failure still

Can you give me an hint…

Thanks
Josef

4

Hi,
the URL you see is the OAuth callback URL that Power BI sends you to in your browser. KNIME has a listener on that URL at that specific port and can retrieve the code Power BI generates after successful authentication from there. After googling your error message it seems like your SSL keystore contains some wrong information (https://stackoverflow.com/questions/9761575/java-nosuchalgorithmexception-sunjsse-sun-security-ssl-sslcontextimpldefault). Have you changed anything regarding SSL in your Knime.ini in KNIME’s installation folder?
Kind regards
Alexander

2 Likes
5

Hi Alexander!

deleting this SSL Section (was from a Project befor) in KNIME.INI makes my day!
Now Working fine… nice Combo: KNIME Knowledge …would leverage DAX Knowledge - fine! Im not an DAX hero. Also not at all a Knime hero :wink:

Thanks alot for help
Josef

3 Likes
6

Hi Alexander,

Thanks for your reply.
Currently I’m using KNIME in my desktop and not in Azure. What relation Azure has with my KNIME desktop app?
And what we have to do in Azure to link KNIME?

Regards,

Jaqueline

7

Hi,
I assumed your Power BI runs in Azure. Otherwise you have to contact your Power BI administrator to grant access to KNIME.
Kind regards,
Alexander

8

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