topic Re: Python script source error- ADO.net failed to load in Service

Python script source error- ADO.net failed to load

WESTi — Mon, 25 May 2020 11:50:32 GMT

My python script source won't refresh in the service as I get the below error when trying to configure the credentials for the gateway. Any ideas on how to fix this error?

Failed to update data source credentials: ADO.NET: Failed to find or load the registered .Net Framework Data Provider.

Activity ID:	f521323a-dae9-4a6c-8cde-9fc0e5fdcc96
Request ID:	5e1f3796-9df8-0469-77c3-4077f1138e2c
Status code:	400
Time:	Mon May 25 2020 23:34:44 GMT+1200 (New Zealand Standard Time)
Service version:	13.0.13322.215
Client version:	2005.2.01092-train
Cluster URI:	https://wabi-australia-east-a-primary-redirect.analysis.windows.net/

Re: Python script source error- ADO.net failed to load

nandukrishnavs — Mon, 25 May 2020 12:31:47 GMT

WESTi

It might be related to the .NET Framework. Please re-installed .NET framework and restarted the server.

https://support.microsoft.com/en-us/help/3186500/the-net-framework-4-7-web-installer-for-windows

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

Re: Python script source error- ADO.net failed to load

Anonymous — Tue, 26 May 2020 01:37:06 GMT

Hi WESTi,

It seems like .net frame environment issue on your device, perhaps you can use the official tool to fix your software environment(device who installed the gateway client) and try again.

Microsoft .NET Framework Repair Tool is available

BTW, any specific python libraries are you used in your script? Current power bi service only supports the general packages that listed on official document site:
Create visuals by using R packages in the Power BI service

Regards,

Xiaoxin Sheng

Re: Python script source error- ADO.net failed to load

Anonymous — Tue, 26 May 2020 03:52:38 GMT

Anonymous I had the same problem, but in Windows 10, it works normal, and in Windows server 2019 Datacenter gives this error.

Re: Python script source error- ADO.net failed to load

WESTi — Tue, 26 May 2020 05:18:54 GMT

Hi Anonymous

I tried the repair tool but it didn't resolve my issue.

I am happy to share the entire python script:

import requests import pandas as pd from pandas.io.json import json_normalize request = requests.get('https://corona-api.com/countries') j = request.json() df = json_normalize(j['data']) print(df)

As this is for a python data source (not for a python visual), I thought I could use any library as long as the machine (with the gateway) has it installed.

I will see if I can figure out how to reinstall .NET and see if that helps. Let me know if you have any other ideas 🙂

Re: Python script source error- ADO.net failed to load

nandukrishnavs — Tue, 26 May 2020 05:56:47 GMT

WESTi

I tried to connect the source (https://corona-api.com/countries) using a web connector, but it is returning an error. So, can you try with some other source and test it in python?

Re: Python script source error- ADO.net failed to load

WESTi — Tue, 26 May 2020 09:25:05 GMT

nandukrishnavs

I tried a different API call and it too didn't work. It is working in Power BI desktop but I still get the error when I try to setup the data set refresh in the service.

Re: Python script source error- ADO.net failed to load

Anonymous — Tue, 26 May 2020 17:46:42 GMT

Friend, I returned the Gateway version to 3000.37.35. And it worked again. Success

Re: Python script source error- ADO.net failed to load

Anonymous — Wed, 27 May 2020 04:23:51 GMT

Hey I am having the same problem, can I know how you returned to an earlier version of the gateway?

Re: Python script source error- ADO.net failed to load

Anonymous — Wed, 27 May 2020 04:29:23 GMT

Anonymous I had a download from the April gateway.

Re: Python script source error- ADO.net failed to load

Anonymous — Wed, 27 May 2020 04:35:17 GMT

Hey do you mind sharing that with me? It seems that Microsoft does not allow you to download any previous version?

Thanks

Re: Python script source error- ADO.net failed to load

Anonymous — Wed, 27 May 2020 04:36:54 GMT

Anonymous e-mail!?

Re: Python script source error- ADO.net failed to load

Anonymous — Wed, 27 May 2020 04:37:42 GMT

rigelng1995@gmail.com

thanks a lot

Re: Python script source error- ADO.net failed to load

WESTi — Wed, 27 May 2020 04:45:09 GMT

If you could share with me too (casey.toia@gmail.com), that would be great as I would like to try also.

Thanks 🙂

Re: Python script source error- ADO.net failed to load

Anonymous — Wed, 27 May 2020 04:58:16 GMT

WESTi and Anonymous

https://drive.google.com/file/d/1_tDyOQ_3vsDHwBv7ISoiYe08YG9oNewa/view?usp=sharing

Try to download it here.

Re: Python script source error- ADO.net failed to load

Anonymous — Wed, 27 May 2020 05:09:26 GMT

Just download and tested and the older version worked like a charm. Thanks a lot, I spend a whole morning trying to debug this. =D

Re: Python script source error- ADO.net failed to load

Anonymous — Wed, 27 May 2020 05:13:43 GMT

😎✌️🏆 Anonymous

Re: Python script source error- ADO.net failed to load

WESTi — Wed, 27 May 2020 07:15:55 GMT

Anonymous **bleep** mate, worked perfect! I have been trying to fix that for an ungodly amount of time.

Anonymous must be a bug in the gateway. Where should I report this?

Re: Python script source error- ADO.net failed to load

gustavoleo — Wed, 27 May 2020 14:39:14 GMT

https://download.microsoft.com/download/6/0/2/602A459E-E1A3-4FB9-B07F-FC2B60881900/On-premises%20data%20gateway%20(personal%20mode)-20-04.exe

Re: Python script source error- ADO.net failed to load

mykbitz — Tue, 02 Jun 2020 20:57:33 GMT