Forum Discussion
Python script source error- ADO.net failed to load
Friend, I returned the Gateway version to 3000.37.35. And it worked again. Success
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
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?
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.
Friend, I returned the Gateway version to 3000.37.35. And it worked again. Success
