Need Help with Python Script Error in Power BI Service During Dataset Refresh

[fbernardazzi]

Hello everyone,

I need some help with an issue I'm experiencing in Power BI. I have two queries: f_dados and W68R_MV_POWERBI_LOG_STATUS_SS. My goal is to compare text values in specific columns from these two queries.

To achieve this, I've created a Python script to calculate the similarity between these columns(Title and SOSE_NM_TITULO) . The script runs perfectly in Power BI Desktop, allowing me to refresh my data without any issues. However, when I publish the dashboard and attempt to refresh the dataset in the Power BI Service, I encounter an error that prevents the update. If I remove the Python script, the dataset refreshes successfully in the published version.

Has anyone encountered a similar issue or have any insights on how to resolve this? Here's the error message I'm receiving:

Thank you in advance for your assistance!

[sergej_og]

@fbernardazzi  There are not enough libraries in Service available.
Pls don't use Python in Service. We tried py also for other purposes bur it failed everytime.

If you have Fabric capabilities pls use Notebooks inside Fabric.
They are working fine.

Regards

[fbernardazzi]

@sergej_og 
Thank you for your response. It’s funny how Python seems to work with other data sources like lists, Excel, and other dataflows, but it consistently encounters issues with this particular one. Unfortunately, I do not have access to Fabric.

Thank you for the alert about using Python, but I am unable to use Fabric due to lack of authorization.

Regards