Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Complete error: Failed to save modifications to the server. Error returned: 'Expression in partition 'n/a' in table 'n/a' references unknown variable or function 'Python.Execute'.
I have this error after used this script to load data:
OBS: This script working in COLAB and Python at my machine, but not in Power Query 😥
Script:
# 'dataset' holds the input data for this script
import numpy as np
import pandas as pd
from pandas_datareader import data as wb
TickerA='ITSA4.SA'
TickerB='FLRY3.SA'
TickerC='LREN3.SA'
dataset=pd.DataFrame()
tickers = [TickerA, TickerB, TickerC]
for t in tickers:
dataset[t]=wb.DataReader(t, data_source='yahoo', start='2019-1-1')['Adj Close']
dataset= dataset.reset_index()
dataset= dataset.set_index([dataset.index])
dataset= dataset.fillna(0)
Solved! Go to Solution.
Hi @apods1979 ,
Sorry for our poor python knowledge, Is "dataset[t]=XXX" a nested tables? Based on this document, Nested tables are currently not supported.
Best regards,
I had a similar problem. Just go to Option > Preview features and uncheck Store dataset using enhanced metadata format.
That should do the trick.
Hey guys, really struggling with this error, any other ideas on how to fix it? I've already tried "Store datasets using enhanced metadata format".
Could you please try the following steps to see if this error can be reproduced:
If it is an urgent issue, We suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/
Best regards,
I run into the same problem. Even when the python script is only: df = dataset, it still returns the error " Failed to save modifications to the server. Error returned: 'Expression in partition 'n/a' in table 'n/a' references unknown variable or function 'Python.Execute'. '." when I try to apply the query.
Hi @apods1979 ,
Does this issue have been resolved? How about the result after you follow the suggestions mentioned by @athulbabuakb? Could you please provide more details about it If it still not be resolved? Please don't contain any Confidential Information or Real data in your reply.
Best regards,
I had a similar problem. Just go to Option > Preview features and uncheck Store dataset using enhanced metadata format.
That should do the trick.
Thank you this works for me as well.
Thank you, that work for me too...
Hi @apods1979 ,
Sorry for our poor python knowledge, Is "dataset[t]=XXX" a nested tables? Based on this document, Nested tables are currently not supported.
Best regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |