Power BI Output tool unable to connect (VM + VPN)

we have already seen this error and it was caused by the SSL validation failing (probably due to VPN). I'll try to get the steps how to deactivate the validation.

We are already working on an official solution.

Vojta

Thank you @VojtechT, it will be very appreciated ! I'm still stuck with this issue...

here are the steps:

open this filefor edit:

%AppData%\Alteryx\Tools\PowerBI_venv\Lib\site-packages\power_bi\utilities\api_requestor.py&#8203;

(if you installed the connector initially for All users as Admin replace the %AppData% with C:\Programdata

locate line 65

response = session.request(method, url, **kwargs)&#8203;

add "verify=False" parameter so the line looks this way

response = session.request(method, url, **kwargs, verify=False)&#8203;

save the file, restart Designer, try Power BI Output again
let me know the result 😉

thank you

@VojtechTI did all these steps, but when I restart Designer and try to authenticate in the Power BI Output Tool via browser, I get a blank window after entering my IDs 😕

can we try to debug it together?

revert the changes done previously
locate %APPDATA%\Alteryx\Tools\PowerBI_venv\Lib\site-packages\power_bi\tools\power_bi_output.py and open it for edit
go to the very end of the file and add "raise" to a new row - better copy/paste all the whitespaces in front of the last row ("self.provider...")
so it looks this way:
save the file, use the connector to get the error
locate %LOCALAPPDATA%\Alteryx\Log folder
there should be new file like "PowerBIxx.txt" where xx is an integer - could you share the file?

Hi @VojtechT, the above "blank window" is solved. It was an Alteryx version issue.

However, I tried your first solution and it did not work : I get the same message...

Concerning the debugging, I add the "raise" but it did not produce the expected log unfortunately :

Thanks again for helping me !

NPT

I have the same issue where a blank window pops up after logging in with my email and password.

@antoine_pac , how about the PowerBI1.log file - could you share the content of that?

Hi @NPT ,

which version of Designer are you using? It's a known issue in 21.3.2 to behave this way. If you can, please downgrade to 21.3.1, which should solve the issue for now.

Hi@VojtechT , I finally get the following expected log file.

PowerBI5.log

thank you for the log. it's clear that this is not caused by the SSL validation error, but for some reason you are not able to reach the endpoint, so there is probably something in your network preventing you from accessing the resource.

what happens if you try to access https://login.microsoftonline.com/common/oauth2/v2.0/token in your browser?

I get nice html page saying "AADSTS900561: The endpoint only accepts POST, OPTIONS requests. Received a GET request." error. That means I am able to get there. What about you?

could you please try the SSL version of this Beta release? On the VM where you had the issues with connecting. Just make sure to use Designer 21.3.1 to avoid the issue with CEF. thank you

NPT

Thanks, @VojtechT.

I did get a reply from Altery Support stating that it is a known issue and I should downgrade.

~ Nathan