Forum Discussion
Python script source error- ADO.net failed to load
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/ |
29 Replies
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 🙂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 serviceRegards,
Xiaoxin Sheng
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 🙂
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?
can not solve with gateway version 3000.37.35.
My problem is "A problem occurred while processing your Python script."
salmon could you give more details? on the server all libraries are installed and the script runs on the python ide?
Yes, I can run with python on my local machine in powerbi desktop normally, but when I publish it and attempt to schedule the refresh, I get an error concerning invalid credentials (Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.). The other data sources connect fine through the personal gateway. When I click on 'Edit Credentials' for Python, I get the following specifics:Failed to update data source credentials: ADO.NET: A problem occurred while processing your Python script. Here are the technical details: Access is denied
Really need the help!! Thanks a lot!
.@salmon I am running the March version (3000.31.3). Could you please share more details, the error you have may not be related to an ADO.net fail.
The situation is that I can run with python on my local machine in powerbi desktop normally, but when I publish it and attempt to schedule the refresh, I get an error concerning invalid credentials (Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.). The other data sources connect fine through the personal gateway. When I click on 'Edit Credentials' for Python, I get the following specifics:Failed to update data source credentials: ADO.NET: A problem occurred while processing your Python script. Here are the technical details: Access is denied
Thanks a lot!
