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.
Hi,
I'm getting the below error while refreshing data on power bi service. The data source is a python script. I have already set the privacy level as public, as suggested in some of the other messages on the BI community but that didn't help. Any idea how to fix this?
There was an error when processing the data in the dataset
Data source error: | {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"ADO.NET: A problem occurred while processing your Python script. \r\nHere are the technical details: Process must exit before requested information can be determined."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Python"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"Python"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.ExceptionType","detail":{"type":1,"value":"Microsoft.PowerBI.Scripting.Python.Exceptions.PythonUnexpectedException"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"A problem occurred while processing your Python script. \r\nHere are the technical details: Process must exit before requested information can be determined."}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: <table_name> |
I am also facing the same scenario. I have a report based on python script. Once published, when I refresh and republish the report, the report at powerbi Services doesn't get refreshed. I have to delete the report and then clear the cache and then republish the report. This has occured post June month update.
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.