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

[antoine_pac]

Hi,

I'm using the Power BI Output Tool for the first time and I face an issue.

Locally, I successfully uploaded a dataset to my workspace using Designer. But if I use the same workflow on a VM (with VPN) I'm getting the error : "failed to connect to platform power bi".

I guess there is a problem with the VPN, but do you have any solutions ?

[VojtechT]

Hi @antoine_pac ,

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

[antoine_pac]

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

[VojtechT]

Hi @antoine_pac ,

here are the steps:

• open this filefor edit: 

%AppData%\Alteryx\Tools\PowerBI_venv\Lib\site-packages\power_bi\utilities\api_requestor.py​

(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)​

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

response = session.request(method, url, **kwargs, verify=False)​

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

thank you

[antoine_pac]

@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 😕

[VojtechT]

Hi @antoine_pac , 

can we try to debug it together?

1. revert the changes done previously
2. locate %APPDATA%\Alteryx\Tools\PowerBI_venv\Lib\site-packages\power_bi\tools\power_bi_output.py and open it for edit
3. 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...")
4. so it looks this way:
5. save the file, use the connector to get the error
6. locate %LOCALAPPDATA%\Alteryx\Log folder
7. there should be new file like "PowerBIxx.txt" where xx is an integer - could you share the file? 

[antoine_pac]

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. 

[VojtechT]

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

[VojtechT]

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.