Python脚本在Power BI中出现NameError错误。

huangapple
go评论165阅读模式
英文:

Python script NameError in power bi

问题

以下是您提供的内容的翻译：

在Power BI桌面应用程序中出现以下名称错误。已经查阅了一些Stack Overflow帖子，但没有帮助。提前致谢。也将同样的问题发布在Power BI社区中。

请参考下面的截图。

Python脚本在Power BI中出现NameError错误。

Python代码：

  1. import matplotlib.pyplot as plt
  2. dataset = pandas.DataFrame(Agent, Resolved)
  3. dataset = dataset.drop_duplicates()
  4. dataset.plot(kind='scatter', x='Agent', y='Resolved', color='green')
  5. plt.show()

尝试的选项：

  1. 卸载并重新安装Power BI桌面应用程序。
  2. 尝试不同版本的Python。
  3. 甚至尝试了Python虚拟环境，但没有成功。

看起来是Python和Power BI版本兼容性问题。

错误堆栈跟踪：

  1. 反馈类型：
  2. Frown（错误）
  4. 错误消息：
  5. Python脚本错误。
  6. <pi>NameError: name 'Agent' is not defined
  7. </pi>
  9. 堆栈跟踪：
  10. JavaScript：错误
  11. Microsoft.PowerBI.ExploreServiceCommon.ScriptHandlerException：Python脚本错误。
  12. NameError：name 'Agent' is not defined
  13. ---&gt; Microsoft.PowerBI.Scripting.Python.Exceptions.PythonScriptRuntimeException：Python脚本错误。
  14. NameError：name 'Agent' is not defined
  15. ...
  16. （此处省略中间内容）
  17. ...
  18. PowerBIUserFeedbackServices_IsReported：
  19. True
英文:

Getting below name error in Power BI-desktop application.Already explored some stack-overflow threads but no help.Thanks in advance.also put same in Power BI community.

Please refer below screenshot.

Python脚本在Power BI中出现NameError错误。

Python code:

  1. import matplotlib.pyplot as plt
  2. dataset = pandas.DataFrame(Agent, Resolved)
  3. dataset = dataset.drop_duplicates()
  4. dataset.plot(kind=&#39;scatter&#39;, x=&#39;Agent&#39;, y=&#39;Resolved&#39;, color=&#39;green&#39;)
  5. plt.show()

option tried:

  1. Uninstall and install power BI desktop application.
  2. Try with different version of python.
     3. Even tried with python virtual environment but no success

Looks like python and power BI version compatibility issue.

Error stack-trace:

  1. Feedback Type:
  2. Frown (Error)
  4. Error Message:
  5. Python script error.
  6. &lt;pi&gt;NameError: name &#39;Agent&#39; is not defined
  7. &lt;/pi&gt;
  9. Stack Trace:
  10. JavaScript: Error
  11. Microsoft.PowerBI.ExploreServiceCommon.ScriptHandlerException: Python script error.
  12. NameError: name &#39;Agent&#39; is not defined
  13. ---&gt; Microsoft.PowerBI.Scripting.Python.Exceptions.PythonScriptRuntimeException: Python script error.
  14. NameError: name &#39;Agent&#39; is not defined
  16. at Microsoft.PowerBI.Scripting.Python.PythonScriptWrapper.RunScript(String originalScript, Int32 timeoutMs)
  17. at Microsoft.PowerBI.Client.Windows.Python.PythonScriptHandler.GenerateVisual(ScriptHandlerOptions options)
  18. --- End of inner exception stack trace ---
  19. at Microsoft.PowerBI.Client.Windows.Python.PythonScriptHandler.GenerateVisual(ScriptHandlerOptions options)
  20. at Microsoft.PowerBI.ExploreHost.SemanticQuery.ScriptVisualCommandFlow.RunInternal(Stream dataShapeResultStream, QueryBindingDescriptor&amp; bindingDescriptor)
  21. at Microsoft.PowerBI.ExploreHost.SemanticQuery.ScriptVisualCommandFlow.Run(Stream dataShapeResultStream, QueryBindingDescriptor&amp; bindingDescriptor)
  22. at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.TransformDataShapeResult(QueryCommand transformCommand, SemanticQueryDataShapeCommand command, Stream dataShapeResultStream, QueryBindingDescriptor&amp; bindingDescriptor)
  23. at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.ExecuteDataQuery(IQueryResultDataWriter queryResultDataWriter, EngineDataModel engineDataModel, DataQuery query, Int32 queryId, ServiceErrorStatusCode&amp; serviceErrorStatusCode, CancellationToken cancelToken)
  24. at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.ProcessAndWriteSemanticQueryCommands(IQueryResultsWriter queryResultsWriter, IList`1 queries, HashSet`1 pendingQueriesToCancel, EngineDataModel engineDataModel)
  26. Stack Trace Message:
  27. Python script error.
  28. &lt;pi&gt;NameError: name &#39;Agent&#39; is not defined
  29. &lt;/pi&gt;
  31. Invocation Stack Trace:
  32. at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
  33. at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
  34. at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
  35. at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
  36. at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.&lt;&gt;c__DisplayClass14_0.&lt;HandleException&gt;b__0()
  37. at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
  38. at Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleException(Exception e)
  39. at Microsoft.PowerBI.Client.Windows.Utilities.PowerBIFormUnexpectedExceptionHandler.HandleException(Exception e)
  40. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
  41. at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
  42. at System.Delegate.DynamicInvokeImpl(Object[] args)
  43. at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
  44. at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
  45. at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
  46. at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
  47. at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
  48. at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
  49. at System.Windows.Forms.WindowsFormsSynchronizationContext.Send(SendOrPostCallback d, Object state)
  50. at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.AllowModalDialogs(Action action)
  51. at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.&lt;&gt;c__DisplayClass14_0.&lt;ExecuteOnUIThreadAndHandlePromise&gt;b__0()
  52. at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.ExecuteOnUIThreadAndHandlePromise[T](Func`1 func, IPromiseStore promiseStore, Int64 promiseHandle)
  53. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
  54. at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
  55. at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
  56. at Microsoft.PowerBI.Client.Windows.WebView2.WebView2Interop.InvokeCs(InteropCall call)
  57. at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
  58. at System.EventHandler`1.Invoke(Object sender, TEventArgs e)
  59. at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG&amp; msg)
  60. at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG&amp; msg)
  61. at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
  62. at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
  63. at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
  64. at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
  65. at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
  66. at Microsoft.PowerBI.Client.Program.&lt;&gt;c__DisplayClass6_0.&lt;RunApplication&gt;b__0()
  67. at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.&lt;&gt;c__DisplayClass3_0.&lt;HandleExceptionsWithNestedTasks&gt;b__0()
  68. at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
  69. at Microsoft.PowerBI.Client.Program.RunApplication(String[] args)
  70. at Microsoft.PowerBI.Client.Program.Main(String[] args)
  73. PowerBINonFatalError:
  74. {&quot;AppName&quot;:&quot;PBIDesktop&quot;,&quot;AppVersion&quot;:&quot;2.118.621.0&quot;,&quot;ModuleName&quot;:&quot;&quot;,&quot;Component&quot;:&quot;&quot;,&quot;Error&quot;:&quot;Error&quot;,&quot;MethodDef&quot;:&quot;&quot;,&quot;ErrorOffset&quot;:&quot;-1:-1&quot;,&quot;ErrorCode&quot;:&quot;&quot;}
  76. Snapshot Trace Logs:
  77. C:\Users\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShotc7961737-aeb3-43dc-8a36-8ba93ecf010a.zip
  79. Model Default Mode:
  80. Import
  82. Model Version:
  83. PowerBI_V3
  85. Performance Trace Logs:
  86. C:\Users\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
  88. Enabled Preview Features:
  89. PBI_enableWebView2
  90. PQ_WebView2Connector
  91. PBI_sparklines
  92. PBI_scorecardVisual
  93. PBI_NlToDax
  94. PBI_fieldParametersSuperSwitch
  95. PBI_horizontalFusion
  96. PBI_setLabelOnExportPdf
  97. PBI_newCard
  99. Disabled Preview Features:
  100. PBI_shapeMapVisualEnabled
  101. PBI_SpanishLinguisticsEnabled
  102. PBI_qnaLiveConnect
  103. PBI_b2bExternalDatasetSharing
  104. PBI_enhancedTooltips
  105. PBI_angularRls
  106. PBI_onObject
  107. PBI_dynamicFormatString
  108. PBI_oneDriveSave
  109. PBI_oneDriveShare
  110. PBI_gitIntegration
  112. Disabled DirectQuery Options:
  113. TreatHanaAsRelationalSource
  115. Cloud:
  116. GlobalCloud
  118. PowerBIUserFeedbackServices_IsReported:
  119. True

答案1

得分: 0

以下是要翻译的内容：

"Got issue actually no need of below lines in python code.

dataset = pandas.DataFrame(Agent, Resolved)
dataset = dataset drop_duplicates()

Its handled internally.Power BI desktop app create temporary folder by name PythonEditorWrapper_XXXX on machine and in same folder data source of pandas frame is present along with python code.

Screenshot of created folder:

Python脚本在Power BI中出现NameError错误。

New bare minimum code to visualize chart.

import matplotlib.pyplot as plt

dataset plot(kind='scatter', x='Agent', y='Resolved', color='green')
plt.show()"

英文:

Got issue actually no need of below lines in python code.

  1. dataset = pandas.DataFrame(Agent, Resolved)
  2. dataset = dataset.drop_duplicates()

Its handled internally.Power BI desktop app create temporary folder by name PythonEditorWrapper_XXXX on machine and in same folder data source of pandas frame is present along with python code.

Screenshot of created folder:

Python脚本在Power BI中出现NameError错误。

New bare minimum code to visualize chart.

  1. import matplotlib.pyplot as plt
  3. dataset.plot(kind=&#39;scatter&#39;, x=&#39;Agent&#39;, y=&#39;Resolved&#39;, color=&#39;green&#39;)
  4. plt.show()

huangapple
  • 本文由 发表于 2023年6月19日 23:40:26
  • 转载请务必保留本文链接：https://go.coder-hub.com/76508159.html
  • powerbi
  • powerbi-desktop
  • python
  • python-3.x
  • windows-10
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定