Issue with Python Data Source: Extension{"extensionDataSourceKind":"Python"} in Power BI Service

[bastianmunoz]

Dear Microsoft Support / Power BI Development Team,

I am writing to report a persistent limitation regarding the use of Python scripts as a data source in Power BI Service, specifically for web scraping tasks.

Currently, when publishing a report that uses Python scripts, the service returns the following error during scheduled refresh:
Extension{"extensionDataSourceKind":"Python","extensionDataSourcePath":"Python"}.

The only known workaround is using the On-premises Data Gateway (Personal Mode). However, this is not a viable solution for enterprise-level environments for the following reasons:

1. Dependency on local hardware: It requires a specific user's computer to be powered on and connected.
2. Scalability: It lacks the robustness and centralized management of the Standard (Enterprise) Gateway.
3. Security and Maintenance: Maintaining individual Python environments on local machines is inefficient.

As of 2025, Python has become a fundamental tool for data engineering and scraping. I kindly request that Microsoft considers:

• Enabling Python execution support within the Standard (Enterprise) Gateway.
• Providing a native cloud environment for Python script execution within the Power BI Service/Fabric capacity.

Improving this integration would significantly enhance the flexibility and reliability of the Power BI platform.

I look forward to hearing about any planned updates regarding this feature.

Best regards,

[KevinChant]

Since you are asking on the Fabric Platform forum, what are you hoping to achieve with the Python scripts? Is it something that could actually be orchestrated in a fabric workspace beforehand which would speed up the report?

[bastianmunoz]

Thank you for your response!

To clarify: I'm using Python to connect to our ISO management platform (Kawak -
https://kawak.com.co), which provides an API for accessing non-conformities,
corrective actions, and audit findings data.

**Current workflow:**
1. Python script authenticates to Kawak API (POST to /login endpoint)
2. Retrieves paginated data from /api/v1/accionesMejora endpoint
3. Consolidates all pages into a single dataset
4. Power BI Desktop consumes this as a table for our compliance dashboard

**The challenge:**
The script works perfectly in Power BI Desktop, but fails in Power BI Service
due to Python data source limitations. The data needs to refresh daily to track
overdue corrective actions across multiple ISO certifications (9001, 14001,
45001, etc.).

[lbendlin · Accepted solution]

Python is not necessary for this. Consider using the standard web connection and Power Query transforms instead.

[v-menakakota]

Hi @bastianmunoz ,
Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank @lbendlin   , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .

Best Regards, 
Community Support Team

[v-menakakota]

Hi  @bastianmunoz ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .

Best Regards, 
Community Support Team 

[lbendlin]

This forum here is the wrong place for your comment. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com