Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello,
I'm working on a Power BI report. I have multiple queries in the Power Query Editor including Python scripts. Suddenly some scripts that did work previously, now give the following error:
DataSource.Error: ADO.NET: A problem occurred while processing your Python script.
Here are the technical details: [Expression.Error] We cannot return a value of type Table in this context.
Details:
DataSourceKind=Python
DataSourcePath=Python
Message=A problem occurred while processing your Python script.
Here are the technical details: [Expression.Error] We cannot return a value of type Table in this context.
ErrorCode=-2147467259
ExceptionType=Microsoft.PowerBI.Scripting.Python.Exceptions.PythonUnexpectedException
Other scripts still work fine. The same simple Python script that works in some queries, does not work for other queries. Any ideas what could be the cause for this, and how to fix it?
My python version is 3.7 (64-bit), and my Microsoft Power BI Desktop version is 2.70.5494.562 64-bit (June 2019).
Thanks for your help!
Rianne
Solved! Go to Solution.
Hi @Anonymous ,
From the Data Source Settings dialog, select the data source(s) and then select Edit Permissions... and ensure that the Privacy Level is set to Public.
Hi @Anonymous ,
From the Data Source Settings dialog, select the data source(s) and then select Edit Permissions... and ensure that the Privacy Level is set to Public.
I met this same problem but can fix by solution here.
my code:
import re
hours_lst = []
for s in zip(dataset['timeSpent']):
p = re.compile("(?P<day>\d+d)?\s*(?P<hour>\d+h)?\s*(?P<minute>\d+m)?")
m = re.search(p, str(s))
day = m.group('day')
day = re.findall("\d+", day)[0] if day else 0
hour = m.group('hour')
hour = re.findall("\d+", hour)[0] if hour else 0
minute = m.group('minute')
minute = re.findall("\d+", minute)[0] if minute else 0
hours = 8*int(day) + int(hour) + float(minute)/60
hours_lst.append(0)
dataset['hours'] = hours_lst
Hi All, unfortunately i have the same problem since installing the June 2019 Power BI update and changing the data source's privacy level to public did not fix the problem. I appreciate any additional support anyone has on this issue.
C:\Users\YouUSER\Anaconda3
C:\Users\YouUSER\Anaconda3\Library\mingw-w64\bin
C:\Users\YouUSER\Anaconda3\Scripts
C:\Users\YouUSER\Anaconda3\Library\bin
That works, thanks a lot!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
24 | |
13 | |
12 | |
11 | |
8 |
User | Count |
---|---|
43 | |
26 | |
16 | |
15 | |
12 |